codekingpro/portable-devtools

1/* contrib/intarray/intarray--1.0--1.1.sql */2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION4\echo Use "ALTER EXTENSION intarray UPDATE TO '1.1'" to load this file. \quit5 6CREATE FUNCTION _int_matchsel(internal, oid, internal, integer)7RETURNS float88AS 'MODULE_PATHNAME'9LANGUAGE C STRICT STABLE;10 11ALTER OPERATOR @@ (_int4, query_int) SET (RESTRICT = _int_matchsel);12ALTER OPERATOR ~~ (query_int, _int4) SET (RESTRICT = _int_matchsel);13 14CREATE FUNCTION _int_overlap_sel(internal, oid, internal, integer)15RETURNS float816AS 'MODULE_PATHNAME'17LANGUAGE C STRICT STABLE;18 19CREATE FUNCTION _int_contains_sel(internal, oid, internal, integer)20RETURNS float821AS 'MODULE_PATHNAME'22LANGUAGE C STRICT STABLE;23 24CREATE FUNCTION _int_contained_sel(internal, oid, internal, integer)25RETURNS float826AS 'MODULE_PATHNAME'27LANGUAGE C STRICT STABLE;28 29CREATE FUNCTION _int_overlap_joinsel(internal, oid, internal, smallint, internal)30RETURNS float831AS 'MODULE_PATHNAME'32LANGUAGE C STRICT STABLE;33 34CREATE FUNCTION _int_contains_joinsel(internal, oid, internal, smallint, internal)35RETURNS float836AS 'MODULE_PATHNAME'37LANGUAGE C STRICT STABLE;38 39CREATE FUNCTION _int_contained_joinsel(internal, oid, internal, smallint, internal)40RETURNS float841AS 'MODULE_PATHNAME'42LANGUAGE C STRICT STABLE;43 44ALTER OPERATOR && (_int4, _int4) SET (RESTRICT = _int_overlap_sel, JOIN = _int_overlap_joinsel);45ALTER OPERATOR @> (_int4, _int4) SET (RESTRICT = _int_contains_sel, JOIN = _int_contains_joinsel);46ALTER OPERATOR <@ (_int4, _int4) SET (RESTRICT = _int_contained_sel, JOIN = _int_contained_joinsel);47 48ALTER OPERATOR @ (_int4, _int4) SET (RESTRICT = _int_contains_sel, JOIN = _int_contains_joinsel);49ALTER OPERATOR ~ (_int4, _int4) SET (RESTRICT = _int_contained_sel, JOIN = _int_contained_joinsel);50