Referencia del Archivo src/libpq/include/utils/selfuncs.h

#include "fmgr.h"
#include "nodes/relation.h"

Ir al código fuente de este archivo.

'defines'
#define	DEFAULT_EQ_SEL   0.005
#define	DEFAULT_INEQ_SEL   0.3333333333333333
#define	DEFAULT_RANGE_INEQ_SEL   0.005
#define	DEFAULT_MATCH_SEL   0.005
#define	DEFAULT_NUM_DISTINCT   200
#define	DEFAULT_UNK_SEL   0.005
#define	DEFAULT_NOT_UNK_SEL   (1.0 - DEFAULT_UNK_SEL)
#define	CLAMP_PROBABILITY(p)
Enumeraciones
enum	Pattern_Type { Pattern_Type_Like, Pattern_Type_Like_IC, Pattern_Type_Regex, Pattern_Type_Regex_IC }
enum	Pattern_Prefix_Status { Pattern_Prefix_None, Pattern_Prefix_Partial, Pattern_Prefix_Exact }
Funciones
Pattern_Prefix_Status	pattern_fixed_prefix (Const *patt, Pattern_Type ptype, Const **prefix, Const **rest)
Const *	make_greater_string (const Const *str_const)
Datum	eqsel (PG_FUNCTION_ARGS)
Datum	neqsel (PG_FUNCTION_ARGS)
Datum	scalarltsel (PG_FUNCTION_ARGS)
Datum	scalargtsel (PG_FUNCTION_ARGS)
Datum	regexeqsel (PG_FUNCTION_ARGS)
Datum	icregexeqsel (PG_FUNCTION_ARGS)
Datum	likesel (PG_FUNCTION_ARGS)
Datum	iclikesel (PG_FUNCTION_ARGS)
Datum	regexnesel (PG_FUNCTION_ARGS)
Datum	icregexnesel (PG_FUNCTION_ARGS)
Datum	nlikesel (PG_FUNCTION_ARGS)
Datum	icnlikesel (PG_FUNCTION_ARGS)
Datum	eqjoinsel (PG_FUNCTION_ARGS)
Datum	neqjoinsel (PG_FUNCTION_ARGS)
Datum	scalarltjoinsel (PG_FUNCTION_ARGS)
Datum	scalargtjoinsel (PG_FUNCTION_ARGS)
Datum	regexeqjoinsel (PG_FUNCTION_ARGS)
Datum	icregexeqjoinsel (PG_FUNCTION_ARGS)
Datum	likejoinsel (PG_FUNCTION_ARGS)
Datum	iclikejoinsel (PG_FUNCTION_ARGS)
Datum	regexnejoinsel (PG_FUNCTION_ARGS)
Datum	icregexnejoinsel (PG_FUNCTION_ARGS)
Datum	nlikejoinsel (PG_FUNCTION_ARGS)
Datum	icnlikejoinsel (PG_FUNCTION_ARGS)
Selectivity	booltestsel (PlannerInfo *root, BoolTestType booltesttype, Node *arg, int varRelid, JoinType jointype)
Selectivity	nulltestsel (PlannerInfo *root, NullTestType nulltesttype, Node *arg, int varRelid)
void	mergejoinscansel (PlannerInfo *root, Node *clause, Selectivity *leftscan, Selectivity *rightscan)
double	estimate_num_groups (PlannerInfo *root, List *groupExprs, double input_rows)
Selectivity	estimate_hash_bucketsize (PlannerInfo *root, Node *hashkey, double nbuckets)
Datum	btcostestimate (PG_FUNCTION_ARGS)
Datum	rtcostestimate (PG_FUNCTION_ARGS)
Datum	hashcostestimate (PG_FUNCTION_ARGS)
Datum	gistcostestimate (PG_FUNCTION_ARGS)

---

Documentación de los 'defines'

#define CLAMP_PROBABILITY

(

p

)

Valor:

do { \
                if (p < 0.0) \
                        p = 0.0; \
                else if (p > 1.0) \
                        p = 1.0; \
        } while (0)

#define DEFAULT_EQ_SEL   0.005

#define DEFAULT_INEQ_SEL   0.3333333333333333

#define DEFAULT_MATCH_SEL   0.005

#define DEFAULT_NOT_UNK_SEL   (1.0 - DEFAULT_UNK_SEL)

#define DEFAULT_NUM_DISTINCT   200

#define DEFAULT_RANGE_INEQ_SEL   0.005

#define DEFAULT_UNK_SEL   0.005

---

Documentación de las enumeraciones

enum Pattern_Prefix_Status

Valores de enumeraciones:

Pattern_Prefix_None
Pattern_Prefix_Partial
Pattern_Prefix_Exact

enum Pattern_Type

Valores de enumeraciones:

Pattern_Type_Like
Pattern_Type_Like_IC
Pattern_Type_Regex
Pattern_Type_Regex_IC

---

Documentación de las funciones

Selectivity booltestsel	(	PlannerInfo *	root,
		BoolTestType	booltesttype,
		Node *	arg,
		int	varRelid,
		JoinType	jointype
	)

Datum btcostestimate

(

PG_FUNCTION_ARGS

)

Datum eqjoinsel

(

PG_FUNCTION_ARGS

)

Datum eqsel

(

PG_FUNCTION_ARGS

)

Selectivity estimate_hash_bucketsize	(	PlannerInfo *	root,
		Node *	hashkey,
		double	nbuckets
	)

double estimate_num_groups	(	PlannerInfo *	root,
		List *	groupExprs,
		double	input_rows
	)

Datum gistcostestimate

(

PG_FUNCTION_ARGS

)

Datum hashcostestimate

(

PG_FUNCTION_ARGS

)

Datum iclikejoinsel

(

PG_FUNCTION_ARGS

)

Datum iclikesel

(

PG_FUNCTION_ARGS

)

Datum icnlikejoinsel

(

PG_FUNCTION_ARGS

)

Datum icnlikesel

(

PG_FUNCTION_ARGS

)

Datum icregexeqjoinsel

(

PG_FUNCTION_ARGS

)

Datum icregexeqsel

(

PG_FUNCTION_ARGS

)

Datum icregexnejoinsel

(

PG_FUNCTION_ARGS

)

Datum icregexnesel

(

PG_FUNCTION_ARGS

)

Datum likejoinsel

(

PG_FUNCTION_ARGS

)

Datum likesel

(

PG_FUNCTION_ARGS

)

Const* make_greater_string

(

const Const *

str_const

)

void mergejoinscansel	(	PlannerInfo *	root,
		Node *	clause,
		Selectivity *	leftscan,
		Selectivity *	rightscan
	)

Datum neqjoinsel

(

PG_FUNCTION_ARGS

)

Datum neqsel

(

PG_FUNCTION_ARGS

)

Datum nlikejoinsel

(

PG_FUNCTION_ARGS

)

Datum nlikesel

(

PG_FUNCTION_ARGS

)

Selectivity nulltestsel	(	PlannerInfo *	root,
		NullTestType	nulltesttype,
		Node *	arg,
		int	varRelid
	)

Pattern_Prefix_Status pattern_fixed_prefix	(	Const *	patt,
		Pattern_Type	ptype,
		Const **	prefix,
		Const **	rest
	)

Datum regexeqjoinsel

(

PG_FUNCTION_ARGS

)

Datum regexeqsel

(

PG_FUNCTION_ARGS

)

Datum regexnejoinsel

(

PG_FUNCTION_ARGS

)

Datum regexnesel

(

PG_FUNCTION_ARGS

)

Datum rtcostestimate

(

PG_FUNCTION_ARGS

)

Datum scalargtjoinsel

(

PG_FUNCTION_ARGS

)

Datum scalargtsel

(

PG_FUNCTION_ARGS

)

Datum scalarltjoinsel

(

PG_FUNCTION_ARGS

)

Datum scalarltsel

(

PG_FUNCTION_ARGS

)