DATA = btree_gist--1.0--1.1.sql \

btree_gist--1.1--1.2.sql btree_gist--1.2.sql btree_gist--1.2--1.3.sql \

btree_gist--1.3--1.4.sql btree_gist--1.4--1.5.sql \

btree_gist--1.5--1.6.sql btree_gist--1.6--1.7.sql \

btree_gist--1.7--1.8.sql

btree_gist--1.5--1.6.sql btree_gist--1.6--1.7.sql

PGFILEDESC = "btree_gist - B-tree equivalent GiST operator classes"

REGRESS = init int2 int4 int8 float4 float8 cash oid timestamp timestamptz \

time timetz date interval macaddr macaddr8 inet cidr text varchar char \

bytea bit varbit numeric uuid not_equal enum bool partitions \

stratnum without_overlaps

bytea bit varbit numeric uuid not_equal enum bool partitions

SHLIB_LINK += $(filter -lm, $(LIBS))

*/

#include "postgres.h"

#include "access/stratnum.h"

#include "utils/builtins.h"

PG_MODULE_MAGIC;

PG_FUNCTION_INFO_V1(gbt_decompress);

PG_FUNCTION_INFO_V1(gbtreekey_in);

PG_FUNCTION_INFO_V1(gbtreekey_out);

PG_FUNCTION_INFO_V1(gist_stratnum_btree);

/**************************************************

* In/Out for keys

{

PG_RETURN_POINTER(PG_GETARG_POINTER(0));

}

/*

* Returns the btree number for supported operators, otherwise invalid.

*/

Datum

gist_stratnum_btree(PG_FUNCTION_ARGS)

{

StrategyNumber strat = PG_GETARG_UINT16(0);

switch (strat)

{

case RTEqualStrategyNumber:

PG_RETURN_UINT16(BTEqualStrategyNumber);

case RTLessStrategyNumber:

PG_RETURN_UINT16(BTLessStrategyNumber);

case RTLessEqualStrategyNumber:

PG_RETURN_UINT16(BTLessEqualStrategyNumber);

case RTGreaterStrategyNumber:

PG_RETURN_UINT16(BTGreaterStrategyNumber);

case RTGreaterEqualStrategyNumber:

PG_RETURN_UINT16(BTGreaterEqualStrategyNumber);

default:

PG_RETURN_UINT16(InvalidStrategy);

}

}

# btree_gist extension

comment = 'support for indexing common datatypes in GiST'

default_version = '1.8'

default_version = '1.7'

module_pathname = '$libdir/btree_gist'

relocatable = true

trusted = true

'btree_gist--1.4--1.5.sql',

'btree_gist--1.5--1.6.sql',

'btree_gist--1.6--1.7.sql',

'btree_gist--1.7--1.8.sql',

kwargs: contrib_data_args,

)

'enum',

'bool',

'partitions',

'stratnum',

'without_overlaps',

],

},

}

</para></entry>

</row>

<row>

<entry role="catalog_table_entry"><para role="column_definition">

<structfield>conperiod</structfield> <type>bool</type>

</para>

<para>

This constraint is defined with <literal>WITHOUT OVERLAPS</literal>

(for primary keys and unique constraints) or <literal>PERIOD</literal>

(for foreign keys).

</para></entry>

</row>

<row>

<entry role="catalog_table_entry"><para role="column_definition">

<structfield>conkey</structfield> <type>int2[]</type>