/* * contrib / btree_gin / btree_gin . c #include "postgres.h" #include <limits.h>#include "access/stratnum.h" #include "utils/builtins.h" #include "utils/date.h" #include "utils/float.h" #include "utils/inet.h" #include "utils/numeric.h" #include "utils/timestamp.h" #include "utils/uuid.h" "btree_gin" ,typedef struct QueryInfobool is_varlena;/*** GIN support functions shared by all datatypes ***/ static Datumbool is_varlena)0 );1 );sizeof (Datum));if (is_varlena)0 ] = datum;1 ;/* * For BTGreaterEqualStrategyNumber , BTGreaterStrategyNumber , and * BTEqualStrategyNumber we want to start the index scan at the * supplied query datum , and work forward . For BTLessStrategyNumber * and BTLessEqualStrategyNumber , we need to start at the leftmost * key , and work forward until the supplied query datum ( which must be * sent along inside the QueryInfo structure ) . static Datumbool is_varlena,void ),0 );1 );2 );bool **partialmatch = (bool **) PG_GETARG_POINTER(3 );4 );sizeof (Datum));sizeof (QueryInfo));bool *ptr_partialmatch;1 ;bool *) palloc(sizeof (bool ));false ;if (is_varlena)sizeof (Pointer));switch (strategy)case BTLessStrategyNumber:case BTLessEqualStrategyNumber:0 ] = leftmostvalue();true ;break ;case BTGreaterEqualStrategyNumber:case BTGreaterStrategyNumber:true ;/* FALLTHROUGH */ case BTEqualStrategyNumber:0 ] = datum;break ;default :"unrecognized strategy number: %d" , strategy);/* * Datum a is a value from extract_query method and for BTLess * * strategy it is a left - most value . So , use original datum from QueryInfo * to decide to stop scanning or not . Datum b is always from index . static Datum0 );1 );3 );switch (data->strategy)case BTLessStrategyNumber:/* If original datum > indexed one then return match */ if (cmp > 0 )0 ;else 1 ;break ;case BTLessEqualStrategyNumber:/* The same except equality */ if (cmp >= 0 )0 ;else 1 ;break ;case BTEqualStrategyNumber:if (cmp != 0 )1 ;else 0 ;break ;case BTGreaterEqualStrategyNumber:/* If original datum <= indexed one then return match */ if (cmp <= 0 )0 ;else 1 ;break ;case BTGreaterStrategyNumber:/* If original datum <= indexed one then return match */ /* If original datum == indexed one then continue scan */ if (cmp < 0 )0 ;else if (cmp == 0 )1 ;else 1 ;break ;default :"unrecognized strategy number: %d" ,0 ;bool *recheck = (bool *) PG_GETARG_POINTER(5 );false ;true );/*** GIN_SUPPORT macro defines the datatype specific functions ***/ #define GIN_SUPPORT(type, is_varlena, leftmostvalue, typecmp) \## type); \## type(PG_FUNCTION_ARGS) \return gin_btree_extract_value(fcinfo, is_varlena); \## type); \## type(PG_FUNCTION_ARGS) \return gin_btree_extract_query(fcinfo, \## type); \## type(PG_FUNCTION_ARGS) \return gin_btree_compare_prefix(fcinfo); \/*** Datatype specifications ***/ static Datumvoid )return Int16GetDatum(SHRT_MIN);false , leftmostvalue_int2, btint2cmp)static Datumvoid )return Int32GetDatum(INT_MIN);false , leftmostvalue_int4, btint4cmp)static Datumvoid )return Int64GetDatum(PG_INT64_MIN);false , leftmostvalue_int8, btint8cmp)static Datumvoid )return Float4GetDatum(-get_float4_infinity());false , leftmostvalue_float4, btfloat4cmp)static Datumvoid )return Float8GetDatum(-get_float8_infinity());false , leftmostvalue_float8, btfloat8cmp)static Datumvoid )return Int64GetDatum(PG_INT64_MIN);false , leftmostvalue_money, cash_cmp)static Datumvoid )return ObjectIdGetDatum(0 );false , leftmostvalue_oid, btoidcmp)static Datumvoid )return TimestampGetDatum(DT_NOBEGIN);false , leftmostvalue_timestamp, timestamp_cmp)false , leftmostvalue_timestamp, timestamp_cmp)static Datumvoid )return TimeADTGetDatum(0 );false , leftmostvalue_time, time_cmp)static Datumvoid )sizeof (TimeTzADT));0 ;24 * 3600 ; /* XXX is that true? */ return TimeTzADTPGetDatum(v);false , leftmostvalue_timetz, timetz_cmp)static Datumvoid )return DateADTGetDatum(DATEVAL_NOBEGIN);false , leftmostvalue_date, date_cmp)static Datumvoid )sizeof (Interval));return IntervalPGetDatum(v);false , leftmostvalue_interval, interval_cmp)static Datumvoid )sizeof (macaddr));return MacaddrPGetDatum(v);false , leftmostvalue_macaddr, macaddr_cmp)static Datumvoid )sizeof (macaddr8));return Macaddr8PGetDatum(v);false , leftmostvalue_macaddr8, macaddr8_cmp)static Datumvoid )return DirectFunctionCall1(inet_in, CStringGetDatum("0.0.0.0/0" ));true , leftmostvalue_inet, network_cmp)true , leftmostvalue_inet, network_cmp)static Datumvoid )return PointerGetDatum(cstring_to_text_with_len("" , 0 ));true , leftmostvalue_text, bttextcmp)true , leftmostvalue_text, bpcharcmp)static Datumvoid )return CharGetDatum(0 );char , false , leftmostvalue_char, btcharcmp)true , leftmostvalue_text, byteacmp)static Datumvoid )return DirectFunctionCall3(bit_in,"" ),0 ),1 ));true , leftmostvalue_bit, bitcmp)static Datumvoid )return DirectFunctionCall3(varbit_in,"" ),0 ),1 ));true , leftmostvalue_varbit, bitcmp)/* * Numeric type hasn ' t a real left - most value , so we use PointerGetDatum ( NULL ) * ( * not * a SQL NULL ) to represent that . We can get away with that because * the value returned by our leftmostvalue function will never be stored in * the index nor passed to anything except our compare and prefix - comparison * functions . The same trick could be used for other pass - by - reference types . #define NUMERIC_IS_LEFTMOST(x) ((x) == NULL)0 );1 );int res = 0 ;if (NUMERIC_IS_LEFTMOST(a))0 : -1 ;else if (NUMERIC_IS_LEFTMOST(b))1 ;else static Datumvoid )return PointerGetDatum(NULL);true , leftmostvalue_numeric, gin_numeric_cmp)/* * Use a similar trick to that used for numeric for enums , since we don ' t * actually know the leftmost value of any enum without knowing the concrete * type , so we use a dummy leftmost value of InvalidOid . * * Note that we use CallerFInfoFunctionCall2 here so that enum_cmp * gets a valid fn_extra to work with . Unlike most other type comparison * routines it needs it , so we can ' t use DirectFunctionCall2 . #define ENUM_IS_LEFTMOST(x) ((x) == InvalidOid)0 );1 );int res = 0 ;if (ENUM_IS_LEFTMOST(a))0 : -1 ;else if (ENUM_IS_LEFTMOST(b))1 ;else static Datumvoid )return ObjectIdGetDatum(InvalidOid);false , leftmostvalue_enum, gin_enum_cmp)static Datumvoid )/* * palloc0 will create the UUID with all zeroes : * " 00000000 - 0000 - 0000 - 0000 - 000000000000 " sizeof (pg_uuid_t));return UUIDPGetDatum(retval);false , leftmostvalue_uuid, uuid_cmp)static Datumvoid )return NameGetDatum(result);false , leftmostvalue_name, btnamecmp)static Datumvoid )return BoolGetDatum(false );bool , false , leftmostvalue_bool, btboolcmp)
Messung V0.5 in Prozent C=94 H=93 G=93
¤ Dauer der Verarbeitung: 0.13 Sekunden
(vorverarbeitet am 2026-08-08)
¤ *© Formatika GbR, Deutschland
