contrib/chkpass/chkpass.sql.in

   1 /* $PostgreSQL$ */
   2
   3 -- Adjust this setting to control where the objects get created.
   4 SET search_path = public;
   5
   6 --
   7 --      Input and output functions and the type itself:
   8 --
   9
  10 CREATE OR REPLACE FUNCTION chkpass_in(cstring)
  11         RETURNS chkpass
  12         AS 'MODULE_PATHNAME'
  13         LANGUAGE C STRICT;
  14
  15 CREATE OR REPLACE FUNCTION chkpass_out(chkpass)
  16         RETURNS cstring
  17         AS 'MODULE_PATHNAME'
  18         LANGUAGE C STRICT;
  19
  20 CREATE TYPE chkpass (
  21         internallength = 16,
  22         externallength = 13,
  23         input = chkpass_in,
  24         output = chkpass_out
  25 );
  26
  27 CREATE OR REPLACE FUNCTION raw(chkpass)
  28         RETURNS text
  29         AS 'MODULE_PATHNAME', 'chkpass_rout'
  30         LANGUAGE C STRICT;
  31
  32 --
  33 --      The various boolean tests:
  34 --
  35
  36 CREATE OR REPLACE FUNCTION eq(chkpass, text)
  37         RETURNS bool
  38         AS 'MODULE_PATHNAME', 'chkpass_eq'
  39         LANGUAGE C STRICT;
  40
  41 CREATE OR REPLACE FUNCTION ne(chkpass, text)
  42         RETURNS bool
  43         AS 'MODULE_PATHNAME', 'chkpass_ne'
  44         LANGUAGE C STRICT;
  45
  46 --
  47 --      Now the operators.
  48 --
  49
  50 CREATE OPERATOR = (
  51         leftarg = chkpass,
  52         rightarg = text,
  53         negator = <>,
  54         procedure = eq
  55 );
  56
  57 CREATE OPERATOR <> (
  58         leftarg = chkpass,
  59         rightarg = text,
  60         negator = =,
  61         procedure = ne
  62 );
  63
  64 COMMENT ON TYPE chkpass IS 'password type with checks';
  65
  66 --
  67 --      eof
  68 --