codekingpro/portable-devtools

1/* contrib/citext/citext--1.4--1.5.sql */2 3-- complain if script is sourced in psql, rather than via ALTER EXTENSION4\echo Use "ALTER EXTENSION citext UPDATE TO '1.5'" to load this file. \quit5 6ALTER OPERATOR <= (citext, citext) SET (7    RESTRICT   = scalarlesel,8    JOIN       = scalarlejoinsel9);10 11ALTER OPERATOR >= (citext, citext) SET (12    RESTRICT   = scalargesel,13    JOIN       = scalargejoinsel14);15 16CREATE FUNCTION citext_pattern_lt( citext, citext )17RETURNS bool18AS 'MODULE_PATHNAME'19LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;20 21CREATE FUNCTION citext_pattern_le( citext, citext )22RETURNS bool23AS 'MODULE_PATHNAME'24LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;25 26CREATE FUNCTION citext_pattern_gt( citext, citext )27RETURNS bool28AS 'MODULE_PATHNAME'29LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;30 31CREATE FUNCTION citext_pattern_ge( citext, citext )32RETURNS bool33AS 'MODULE_PATHNAME'34LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE;35 36CREATE OPERATOR ~<~ (37    LEFTARG    = CITEXT,38    RIGHTARG   = CITEXT,39    NEGATOR    = ~>=~,40    COMMUTATOR = ~>~,41    PROCEDURE  = citext_pattern_lt,42    RESTRICT   = scalarltsel,43    JOIN       = scalarltjoinsel44);45 46CREATE OPERATOR ~<=~ (47    LEFTARG    = CITEXT,48    RIGHTARG   = CITEXT,49    NEGATOR    = ~>~,50    COMMUTATOR = ~>=~,51    PROCEDURE  = citext_pattern_le,52    RESTRICT   = scalarltsel,53    JOIN       = scalarltjoinsel54);55 56CREATE OPERATOR ~>=~ (57    LEFTARG    = CITEXT,58    RIGHTARG   = CITEXT,59    NEGATOR    = ~<~,60    COMMUTATOR = ~<=~,61    PROCEDURE  = citext_pattern_ge,62    RESTRICT   = scalargtsel,63    JOIN       = scalargtjoinsel64);65 66CREATE OPERATOR ~>~ (67    LEFTARG    = CITEXT,68    RIGHTARG   = CITEXT,69    NEGATOR    = ~<=~,70    COMMUTATOR = ~<~,71    PROCEDURE  = citext_pattern_gt,72    RESTRICT   = scalargtsel,73    JOIN       = scalargtjoinsel74);75 76CREATE FUNCTION citext_pattern_cmp(citext, citext)77RETURNS int478AS 'MODULE_PATHNAME'79LANGUAGE C STRICT IMMUTABLE PARALLEL SAFE;80 81CREATE OPERATOR CLASS citext_pattern_ops82FOR TYPE CITEXT USING btree AS83    OPERATOR    1   ~<~  (citext, citext),84    OPERATOR    2   ~<=~ (citext, citext),85    OPERATOR    3   =    (citext, citext),86    OPERATOR    4   ~>=~ (citext, citext),87    OPERATOR    5   ~>~  (citext, citext),88    FUNCTION    1   citext_pattern_cmp(citext, citext);89