summaryrefslogtreecommitdiff
path: root/contrib/chkpass/chkpass--1.0.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/chkpass/chkpass--1.0.sql')
-rw-r--r--contrib/chkpass/chkpass--1.0.sql70
1 files changed, 0 insertions, 70 deletions
diff --git a/contrib/chkpass/chkpass--1.0.sql b/contrib/chkpass/chkpass--1.0.sql
deleted file mode 100644
index 406a61924cc..00000000000
--- a/contrib/chkpass/chkpass--1.0.sql
+++ /dev/null
@@ -1,70 +0,0 @@
-/* contrib/chkpass/chkpass--1.0.sql */
-
--- complain if script is sourced in psql, rather than via CREATE EXTENSION
-\echo Use "CREATE EXTENSION chkpass" to load this file. \quit
-
---
--- Input and output functions and the type itself:
---
-
-CREATE FUNCTION chkpass_in(cstring)
- RETURNS chkpass
- AS 'MODULE_PATHNAME'
- LANGUAGE C STRICT VOLATILE;
--- Note: chkpass_in actually is volatile, because of its use of random().
--- In hindsight that was a bad idea, but there's no way to change it without
--- breaking some usage patterns.
-
-CREATE FUNCTION chkpass_out(chkpass)
- RETURNS cstring
- AS 'MODULE_PATHNAME'
- LANGUAGE C STRICT IMMUTABLE;
-
-CREATE TYPE chkpass (
- internallength = 16,
- input = chkpass_in,
- output = chkpass_out
-);
-
-CREATE FUNCTION raw(chkpass)
- RETURNS text
- AS 'MODULE_PATHNAME', 'chkpass_rout'
- LANGUAGE C STRICT;
-
---
--- The various boolean tests:
---
-
-CREATE FUNCTION eq(chkpass, text)
- RETURNS bool
- AS 'MODULE_PATHNAME', 'chkpass_eq'
- LANGUAGE C STRICT;
-
-CREATE FUNCTION ne(chkpass, text)
- RETURNS bool
- AS 'MODULE_PATHNAME', 'chkpass_ne'
- LANGUAGE C STRICT;
-
---
--- Now the operators.
---
-
-CREATE OPERATOR = (
- leftarg = chkpass,
- rightarg = text,
- negator = <>,
- procedure = eq
-);
-
-CREATE OPERATOR <> (
- leftarg = chkpass,
- rightarg = text,
- negator = =,
- procedure = ne
-);
-
-COMMENT ON TYPE chkpass IS 'password type with checks';
-
---
--- eof
---