[Summary view] [Print] [Text view]

   1  
   2  BEGIN;
   3  
   4  /*
   5      Domain definition
   6  */
   7  CREATE DOMAIN varchar_ci AS varchar(255) NOT NULL DEFAULT ''::character varying;
   8  
   9  /*
  10      Operation Functions
  11  */
  12  CREATE FUNCTION _varchar_ci_equal(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) = LOWER($2)' LANGUAGE SQL STRICT;
  13  CREATE FUNCTION _varchar_ci_not_equal(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) != LOWER($2)' LANGUAGE SQL STRICT;
  14  CREATE FUNCTION _varchar_ci_less_than(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) < LOWER($2)' LANGUAGE SQL STRICT;
  15  CREATE FUNCTION _varchar_ci_less_equal(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) <= LOWER($2)' LANGUAGE SQL STRICT;
  16  CREATE FUNCTION _varchar_ci_greater_than(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) > LOWER($2)' LANGUAGE SQL STRICT;
  17  CREATE FUNCTION _varchar_ci_greater_equals(varchar_ci, varchar_ci) RETURNS boolean AS 'SELECT LOWER($1) >= LOWER($2)' LANGUAGE SQL STRICT;
  18  
  19  /*
  20      Operators
  21  */
  22  CREATE OPERATOR <(
  23    PROCEDURE = _varchar_ci_less_than,
  24    LEFTARG = varchar_ci,
  25    RIGHTARG = varchar_ci,
  26    COMMUTATOR = >,
  27    NEGATOR = >=,
  28    RESTRICT = scalarltsel,
  29    JOIN = scalarltjoinsel);
  30  
  31  CREATE OPERATOR <=(
  32    PROCEDURE = _varchar_ci_less_equal,
  33    LEFTARG = varchar_ci,
  34    RIGHTARG = varchar_ci,
  35    COMMUTATOR = >=,
  36    NEGATOR = >,
  37    RESTRICT = scalarltsel,
  38    JOIN = scalarltjoinsel);
  39  
  40  CREATE OPERATOR >(
  41    PROCEDURE = _varchar_ci_greater_than,
  42    LEFTARG = varchar_ci,
  43    RIGHTARG = varchar_ci,
  44    COMMUTATOR = <,
  45    NEGATOR = <=,
  46    RESTRICT = scalargtsel,
  47    JOIN = scalargtjoinsel);
  48  
  49  CREATE OPERATOR >=(
  50    PROCEDURE = _varchar_ci_greater_equals,
  51    LEFTARG = varchar_ci,
  52    RIGHTARG = varchar_ci,
  53    COMMUTATOR = <=,
  54    NEGATOR = <,
  55    RESTRICT = scalargtsel,
  56    JOIN = scalargtjoinsel);
  57  
  58  CREATE OPERATOR <>(
  59    PROCEDURE = _varchar_ci_not_equal,
  60    LEFTARG = varchar_ci,
  61    RIGHTARG = varchar_ci,
  62    COMMUTATOR = <>,
  63    NEGATOR = =,
  64    RESTRICT = neqsel,
  65    JOIN = neqjoinsel);
  66  
  67  CREATE OPERATOR =(
  68    PROCEDURE = _varchar_ci_equal,
  69    LEFTARG = varchar_ci,
  70    RIGHTARG = varchar_ci,
  71    COMMUTATOR = =,
  72    NEGATOR = <>,
  73    RESTRICT = eqsel,
  74    JOIN = eqjoinsel,
  75    HASHES,
  76    MERGES,
  77    SORT1= <);
  78  
  79  COMMIT;
  80