Submit
Path:
~
/
/
usr
/
share
/
pgsql
/
extension
/
File Content:
isn--1.1.sql
/* contrib/isn/isn--1.1.sql */ -- complain if script is sourced in psql, rather than via CREATE EXTENSION \echo Use "CREATE EXTENSION isn" to load this file. \quit -- Example: -- create table test ( id isbn ); -- insert into test values('978-0-393-04002-9'); -- -- select isbn('978-0-393-04002-9'); -- select isbn13('0-901690-54-6'); -- -- -- Input and output functions and data types: -- --------------------------------------------------- CREATE FUNCTION ean13_in(cstring) RETURNS ean13 AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION ean13_out(ean13) RETURNS cstring AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE TYPE ean13 ( INPUT = ean13_in, OUTPUT = ean13_out, LIKE = pg_catalog.int8 ); COMMENT ON TYPE ean13 IS 'International European Article Number (EAN13)'; CREATE FUNCTION isbn13_in(cstring) RETURNS isbn13 AS 'MODULE_PATHNAME', 'isbn_in' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION ean13_out(isbn13) RETURNS cstring AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE TYPE isbn13 ( INPUT = isbn13_in, OUTPUT = ean13_out, LIKE = pg_catalog.int8 ); COMMENT ON TYPE isbn13 IS 'International Standard Book Number 13 (ISBN13)'; CREATE FUNCTION ismn13_in(cstring) RETURNS ismn13 AS 'MODULE_PATHNAME', 'ismn_in' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION ean13_out(ismn13) RETURNS cstring AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE TYPE ismn13 ( INPUT = ismn13_in, OUTPUT = ean13_out, LIKE = pg_catalog.int8 ); COMMENT ON TYPE ismn13 IS 'International Standard Music Number 13 (ISMN13)'; CREATE FUNCTION issn13_in(cstring) RETURNS issn13 AS 'MODULE_PATHNAME', 'issn_in' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION ean13_out(issn13) RETURNS cstring AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE TYPE issn13 ( INPUT = issn13_in, OUTPUT = ean13_out, LIKE = pg_catalog.int8 ); COMMENT ON TYPE issn13 IS 'International Standard Serial Number 13 (ISSN13)'; -- Short format: CREATE FUNCTION isbn_in(cstring) RETURNS isbn AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isn_out(isbn) RETURNS cstring AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE TYPE isbn ( INPUT = isbn_in, OUTPUT = isn_out, LIKE = pg_catalog.int8 ); COMMENT ON TYPE isbn IS 'International Standard Book Number (ISBN)'; CREATE FUNCTION ismn_in(cstring) RETURNS ismn AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isn_out(ismn) RETURNS cstring AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE TYPE ismn ( INPUT = ismn_in, OUTPUT = isn_out, LIKE = pg_catalog.int8 ); COMMENT ON TYPE ismn IS 'International Standard Music Number (ISMN)'; CREATE FUNCTION issn_in(cstring) RETURNS issn AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isn_out(issn) RETURNS cstring AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE TYPE issn ( INPUT = issn_in, OUTPUT = isn_out, LIKE = pg_catalog.int8 ); COMMENT ON TYPE issn IS 'International Standard Serial Number (ISSN)'; CREATE FUNCTION upc_in(cstring) RETURNS upc AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isn_out(upc) RETURNS cstring AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE TYPE upc ( INPUT = upc_in, OUTPUT = isn_out, LIKE = pg_catalog.int8 ); COMMENT ON TYPE upc IS 'Universal Product Code (UPC)'; -- -- Operator functions: -- --------------------------------------------------- -- EAN13: CREATE FUNCTION isnlt(ean13, ean13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(ean13, ean13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(ean13, ean13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(ean13, ean13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(ean13, ean13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(ean13, ean13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(ean13, isbn13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(ean13, isbn13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(ean13, isbn13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(ean13, isbn13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(ean13, isbn13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(ean13, isbn13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(ean13, ismn13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(ean13, ismn13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(ean13, ismn13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(ean13, ismn13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(ean13, ismn13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(ean13, ismn13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(ean13, issn13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(ean13, issn13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(ean13, issn13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(ean13, issn13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(ean13, issn13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(ean13, issn13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(ean13, isbn) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(ean13, isbn) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(ean13, isbn) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(ean13, isbn) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(ean13, isbn) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(ean13, isbn) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(ean13, ismn) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(ean13, ismn) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(ean13, ismn) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(ean13, ismn) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(ean13, ismn) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(ean13, ismn) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(ean13, issn) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(ean13, issn) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(ean13, issn) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(ean13, issn) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(ean13, issn) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(ean13, issn) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(ean13, upc) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(ean13, upc) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(ean13, upc) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(ean13, upc) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(ean13, upc) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(ean13, upc) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; --------------------------------------------------- -- ISBN13: CREATE FUNCTION isnlt(isbn13, isbn13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(isbn13, isbn13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(isbn13, isbn13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(isbn13, isbn13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(isbn13, isbn13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(isbn13, isbn13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(isbn13, isbn) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(isbn13, isbn) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(isbn13, isbn) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(isbn13, isbn) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(isbn13, isbn) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(isbn13, isbn) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(isbn13, ean13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(isbn13, ean13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(isbn13, ean13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(isbn13, ean13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(isbn13, ean13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(isbn13, ean13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; --------------------------------------------------- -- ISBN: CREATE FUNCTION isnlt(isbn, isbn) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(isbn, isbn) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(isbn, isbn) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(isbn, isbn) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(isbn, isbn) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(isbn, isbn) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(isbn, isbn13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(isbn, isbn13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(isbn, isbn13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(isbn, isbn13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(isbn, isbn13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(isbn, isbn13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(isbn, ean13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(isbn, ean13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(isbn, ean13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(isbn, ean13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(isbn, ean13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(isbn, ean13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; --------------------------------------------------- -- ISMN13: CREATE FUNCTION isnlt(ismn13, ismn13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(ismn13, ismn13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(ismn13, ismn13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(ismn13, ismn13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(ismn13, ismn13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(ismn13, ismn13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(ismn13, ismn) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(ismn13, ismn) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(ismn13, ismn) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(ismn13, ismn) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(ismn13, ismn) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(ismn13, ismn) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(ismn13, ean13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(ismn13, ean13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(ismn13, ean13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(ismn13, ean13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(ismn13, ean13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(ismn13, ean13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; --------------------------------------------------- -- ISMN: CREATE FUNCTION isnlt(ismn, ismn) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(ismn, ismn) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(ismn, ismn) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(ismn, ismn) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(ismn, ismn) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(ismn, ismn) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(ismn, ismn13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(ismn, ismn13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(ismn, ismn13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(ismn, ismn13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(ismn, ismn13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(ismn, ismn13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(ismn, ean13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(ismn, ean13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(ismn, ean13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(ismn, ean13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(ismn, ean13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(ismn, ean13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; --------------------------------------------------- -- ISSN13: CREATE FUNCTION isnlt(issn13, issn13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(issn13, issn13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(issn13, issn13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(issn13, issn13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(issn13, issn13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(issn13, issn13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(issn13, issn) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(issn13, issn) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(issn13, issn) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(issn13, issn) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(issn13, issn) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(issn13, issn) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(issn13, ean13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(issn13, ean13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(issn13, ean13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(issn13, ean13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(issn13, ean13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(issn13, ean13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; --------------------------------------------------- -- ISSN: CREATE FUNCTION isnlt(issn, issn) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(issn, issn) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(issn, issn) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(issn, issn) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(issn, issn) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(issn, issn) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(issn, issn13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(issn, issn13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(issn, issn13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(issn, issn13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(issn, issn13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(issn, issn13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(issn, ean13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(issn, ean13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(issn, ean13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(issn, ean13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(issn, ean13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(issn, ean13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; --------------------------------------------------- -- UPC: CREATE FUNCTION isnlt(upc, upc) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(upc, upc) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(upc, upc) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(upc, upc) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(upc, upc) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(upc, upc) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnlt(upc, ean13) RETURNS boolean AS 'int8lt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnle(upc, ean13) RETURNS boolean AS 'int8le' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isneq(upc, ean13) RETURNS boolean AS 'int8eq' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnge(upc, ean13) RETURNS boolean AS 'int8ge' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isngt(upc, ean13) RETURNS boolean AS 'int8gt' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isnne(upc, ean13) RETURNS boolean AS 'int8ne' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; -- -- Now the operators: -- -- -- EAN13 operators: -- --------------------------------------------------- CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = ean13, RIGHTARG = ean13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = ean13, RIGHTARG = ean13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = ean13, RIGHTARG = ean13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = ean13, RIGHTARG = ean13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = ean13, RIGHTARG = ean13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = ean13, RIGHTARG = ean13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = ean13, RIGHTARG = isbn13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = ean13, RIGHTARG = isbn13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = ean13, RIGHTARG = isbn13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = ean13, RIGHTARG = isbn13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = ean13, RIGHTARG = isbn13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = ean13, RIGHTARG = isbn13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = isbn13, RIGHTARG = ean13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = isbn13, RIGHTARG = ean13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = isbn13, RIGHTARG = ean13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = isbn13, RIGHTARG = ean13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = isbn13, RIGHTARG = ean13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = isbn13, RIGHTARG = ean13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = ean13, RIGHTARG = ismn13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = ean13, RIGHTARG = ismn13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = ean13, RIGHTARG = ismn13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = ean13, RIGHTARG = ismn13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = ean13, RIGHTARG = ismn13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = ean13, RIGHTARG = ismn13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = ismn13, RIGHTARG = ean13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = ismn13, RIGHTARG = ean13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = ismn13, RIGHTARG = ean13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = ismn13, RIGHTARG = ean13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = ismn13, RIGHTARG = ean13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = ismn13, RIGHTARG = ean13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = ean13, RIGHTARG = issn13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = ean13, RIGHTARG = issn13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = ean13, RIGHTARG = issn13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = ean13, RIGHTARG = issn13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = ean13, RIGHTARG = issn13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = ean13, RIGHTARG = issn13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = ean13, RIGHTARG = isbn, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = ean13, RIGHTARG = isbn, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = ean13, RIGHTARG = isbn, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = ean13, RIGHTARG = isbn, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = ean13, RIGHTARG = isbn, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = ean13, RIGHTARG = isbn, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = ean13, RIGHTARG = ismn, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = ean13, RIGHTARG = ismn, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = ean13, RIGHTARG = ismn, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = ean13, RIGHTARG = ismn, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = ean13, RIGHTARG = ismn, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = ean13, RIGHTARG = ismn, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = ean13, RIGHTARG = issn, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = ean13, RIGHTARG = issn, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = ean13, RIGHTARG = issn, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = ean13, RIGHTARG = issn, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = ean13, RIGHTARG = issn, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = ean13, RIGHTARG = issn, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = ean13, RIGHTARG = upc, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = ean13, RIGHTARG = upc, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = ean13, RIGHTARG = upc, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = ean13, RIGHTARG = upc, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = ean13, RIGHTARG = upc, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = ean13, RIGHTARG = upc, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); -- -- ISBN13 operators: -- --------------------------------------------------- CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = isbn13, RIGHTARG = isbn13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = isbn13, RIGHTARG = isbn13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = isbn13, RIGHTARG = isbn13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = isbn13, RIGHTARG = isbn13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = isbn13, RIGHTARG = isbn13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = isbn13, RIGHTARG = isbn13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = isbn13, RIGHTARG = isbn, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = isbn13, RIGHTARG = isbn, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = isbn13, RIGHTARG = isbn, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = isbn13, RIGHTARG = isbn, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = isbn13, RIGHTARG = isbn, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = isbn13, RIGHTARG = isbn, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); -- -- ISBN operators: -- --------------------------------------------------- CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = isbn, RIGHTARG = isbn, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = isbn, RIGHTARG = isbn, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = isbn, RIGHTARG = isbn, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = isbn, RIGHTARG = isbn, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = isbn, RIGHTARG = isbn, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = isbn, RIGHTARG = isbn, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = isbn, RIGHTARG = isbn13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = isbn, RIGHTARG = isbn13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = isbn, RIGHTARG = isbn13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = isbn, RIGHTARG = isbn13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = isbn, RIGHTARG = isbn13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = isbn, RIGHTARG = isbn13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = isbn, RIGHTARG = ean13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = isbn, RIGHTARG = ean13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = isbn, RIGHTARG = ean13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = isbn, RIGHTARG = ean13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = isbn, RIGHTARG = ean13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = isbn, RIGHTARG = ean13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); -- -- ISMN13 operators: -- --------------------------------------------------- CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = ismn13, RIGHTARG = ismn13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = ismn13, RIGHTARG = ismn13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = ismn13, RIGHTARG = ismn13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = ismn13, RIGHTARG = ismn13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = ismn13, RIGHTARG = ismn13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = ismn13, RIGHTARG = ismn13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = ismn13, RIGHTARG = ismn, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = ismn13, RIGHTARG = ismn, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = ismn13, RIGHTARG = ismn, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = ismn13, RIGHTARG = ismn, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = ismn13, RIGHTARG = ismn, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = ismn13, RIGHTARG = ismn, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); -- -- ISMN operators: -- --------------------------------------------------- CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = ismn, RIGHTARG = ismn, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = ismn, RIGHTARG = ismn, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = ismn, RIGHTARG = ismn, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = ismn, RIGHTARG = ismn, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = ismn, RIGHTARG = ismn, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = ismn, RIGHTARG = ismn, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = ismn, RIGHTARG = ismn13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = ismn, RIGHTARG = ismn13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = ismn, RIGHTARG = ismn13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = ismn, RIGHTARG = ismn13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = ismn, RIGHTARG = ismn13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = ismn, RIGHTARG = ismn13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = ismn, RIGHTARG = ean13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = ismn, RIGHTARG = ean13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = ismn, RIGHTARG = ean13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = ismn, RIGHTARG = ean13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = ismn, RIGHTARG = ean13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = ismn, RIGHTARG = ean13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); -- -- ISSN13 operators: -- --------------------------------------------------- CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = issn13, RIGHTARG = issn13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = issn13, RIGHTARG = issn13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = issn13, RIGHTARG = issn13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = issn13, RIGHTARG = issn13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = issn13, RIGHTARG = issn13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = issn13, RIGHTARG = issn13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = issn13, RIGHTARG = issn, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = issn13, RIGHTARG = issn, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = issn13, RIGHTARG = issn, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = issn13, RIGHTARG = issn, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = issn13, RIGHTARG = issn, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = issn13, RIGHTARG = issn, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = issn13, RIGHTARG = ean13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = issn13, RIGHTARG = ean13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = issn13, RIGHTARG = ean13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = issn13, RIGHTARG = ean13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = issn13, RIGHTARG = ean13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = issn13, RIGHTARG = ean13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); -- -- ISSN operators: -- --------------------------------------------------- CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = issn, RIGHTARG = issn, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = issn, RIGHTARG = issn, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = issn, RIGHTARG = issn, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = issn, RIGHTARG = issn, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = issn, RIGHTARG = issn, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = issn, RIGHTARG = issn, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = issn, RIGHTARG = issn13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = issn, RIGHTARG = issn13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = issn, RIGHTARG = issn13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = issn, RIGHTARG = issn13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = issn, RIGHTARG = issn13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = issn, RIGHTARG = issn13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = issn, RIGHTARG = ean13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = issn, RIGHTARG = ean13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = issn, RIGHTARG = ean13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = issn, RIGHTARG = ean13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = issn, RIGHTARG = ean13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = issn, RIGHTARG = ean13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); -- -- UPC operators: -- --------------------------------------------------- CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = upc, RIGHTARG = upc, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = upc, RIGHTARG = upc, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = upc, RIGHTARG = upc, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = upc, RIGHTARG = upc, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = upc, RIGHTARG = upc, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = upc, RIGHTARG = upc, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); CREATE OPERATOR < ( PROCEDURE = isnlt, LEFTARG = upc, RIGHTARG = ean13, COMMUTATOR = >, NEGATOR = >=, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR <= ( PROCEDURE = isnle, LEFTARG = upc, RIGHTARG = ean13, COMMUTATOR = >=, NEGATOR = >, RESTRICT = scalarltsel, JOIN = scalarltjoinsel); CREATE OPERATOR = ( PROCEDURE = isneq, LEFTARG = upc, RIGHTARG = ean13, COMMUTATOR = =, NEGATOR = <>, RESTRICT = eqsel, JOIN = eqjoinsel, MERGES, HASHES); CREATE OPERATOR >= ( PROCEDURE = isnge, LEFTARG = upc, RIGHTARG = ean13, COMMUTATOR = <=, NEGATOR = <, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR > ( PROCEDURE = isngt, LEFTARG = upc, RIGHTARG = ean13, COMMUTATOR = <, NEGATOR = <=, RESTRICT = scalargtsel, JOIN = scalargtjoinsel ); CREATE OPERATOR <> ( PROCEDURE = isnne, LEFTARG = upc, RIGHTARG = ean13, COMMUTATOR = <>, NEGATOR = =, RESTRICT = neqsel, JOIN = neqjoinsel); -- -- Operator families for the various operator classes: -- --------------------------------------------------- CREATE OPERATOR FAMILY isn_ops USING btree; CREATE OPERATOR FAMILY isn_ops USING hash; -- -- Operator classes: -- --------------------------------------------------- -- EAN13: CREATE FUNCTION btean13cmp(ean13, ean13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS ean13_ops DEFAULT FOR TYPE ean13 USING btree FAMILY isn_ops AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 btean13cmp(ean13, ean13); CREATE FUNCTION hashean13(ean13) RETURNS int4 AS 'hashint8' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS ean13_ops DEFAULT FOR TYPE ean13 USING hash FAMILY isn_ops AS OPERATOR 1 =, FUNCTION 1 hashean13(ean13); -- EAN13 vs other types: CREATE FUNCTION btean13cmp(ean13, isbn13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION btean13cmp(ean13, ismn13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION btean13cmp(ean13, issn13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION btean13cmp(ean13, isbn) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION btean13cmp(ean13, ismn) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION btean13cmp(ean13, issn) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION btean13cmp(ean13, upc) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; ALTER OPERATOR FAMILY isn_ops USING btree ADD OPERATOR 1 < (ean13, isbn13), OPERATOR 1 < (ean13, ismn13), OPERATOR 1 < (ean13, issn13), OPERATOR 1 < (ean13, isbn), OPERATOR 1 < (ean13, ismn), OPERATOR 1 < (ean13, issn), OPERATOR 1 < (ean13, upc), OPERATOR 2 <= (ean13, isbn13), OPERATOR 2 <= (ean13, ismn13), OPERATOR 2 <= (ean13, issn13), OPERATOR 2 <= (ean13, isbn), OPERATOR 2 <= (ean13, ismn), OPERATOR 2 <= (ean13, issn), OPERATOR 2 <= (ean13, upc), OPERATOR 3 = (ean13, isbn13), OPERATOR 3 = (ean13, ismn13), OPERATOR 3 = (ean13, issn13), OPERATOR 3 = (ean13, isbn), OPERATOR 3 = (ean13, ismn), OPERATOR 3 = (ean13, issn), OPERATOR 3 = (ean13, upc), OPERATOR 4 >= (ean13, isbn13), OPERATOR 4 >= (ean13, ismn13), OPERATOR 4 >= (ean13, issn13), OPERATOR 4 >= (ean13, isbn), OPERATOR 4 >= (ean13, ismn), OPERATOR 4 >= (ean13, issn), OPERATOR 4 >= (ean13, upc), OPERATOR 5 > (ean13, isbn13), OPERATOR 5 > (ean13, ismn13), OPERATOR 5 > (ean13, issn13), OPERATOR 5 > (ean13, isbn), OPERATOR 5 > (ean13, ismn), OPERATOR 5 > (ean13, issn), OPERATOR 5 > (ean13, upc), FUNCTION 1 btean13cmp(ean13, isbn13), FUNCTION 1 btean13cmp(ean13, ismn13), FUNCTION 1 btean13cmp(ean13, issn13), FUNCTION 1 btean13cmp(ean13, isbn), FUNCTION 1 btean13cmp(ean13, ismn), FUNCTION 1 btean13cmp(ean13, issn), FUNCTION 1 btean13cmp(ean13, upc); ALTER OPERATOR FAMILY isn_ops USING hash ADD OPERATOR 1 = (ean13, isbn13), OPERATOR 1 = (ean13, ismn13), OPERATOR 1 = (ean13, issn13), OPERATOR 1 = (ean13, isbn), OPERATOR 1 = (ean13, ismn), OPERATOR 1 = (ean13, issn), OPERATOR 1 = (ean13, upc); --------------------------------------------------- -- ISBN13: CREATE FUNCTION btisbn13cmp(isbn13, isbn13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS isbn13_ops DEFAULT FOR TYPE isbn13 USING btree FAMILY isn_ops AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 btisbn13cmp(isbn13, isbn13); CREATE FUNCTION hashisbn13(isbn13) RETURNS int4 AS 'hashint8' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS isbn13_ops DEFAULT FOR TYPE isbn13 USING hash FAMILY isn_ops AS OPERATOR 1 =, FUNCTION 1 hashisbn13(isbn13); -- ISBN13 vs other types: CREATE FUNCTION btisbn13cmp(isbn13, ean13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION btisbn13cmp(isbn13, isbn) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; ALTER OPERATOR FAMILY isn_ops USING btree ADD OPERATOR 1 < (isbn13, ean13), OPERATOR 1 < (isbn13, isbn), OPERATOR 2 <= (isbn13, ean13), OPERATOR 2 <= (isbn13, isbn), OPERATOR 3 = (isbn13, ean13), OPERATOR 3 = (isbn13, isbn), OPERATOR 4 >= (isbn13, ean13), OPERATOR 4 >= (isbn13, isbn), OPERATOR 5 > (isbn13, ean13), OPERATOR 5 > (isbn13, isbn), FUNCTION 1 btisbn13cmp(isbn13, ean13), FUNCTION 1 btisbn13cmp(isbn13, isbn); ALTER OPERATOR FAMILY isn_ops USING hash ADD OPERATOR 1 = (isbn13, ean13), OPERATOR 1 = (isbn13, isbn); --------------------------------------------------- -- ISBN: CREATE FUNCTION btisbncmp(isbn, isbn) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS isbn_ops DEFAULT FOR TYPE isbn USING btree FAMILY isn_ops AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 btisbncmp(isbn, isbn); CREATE FUNCTION hashisbn(isbn) RETURNS int4 AS 'hashint8' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS isbn_ops DEFAULT FOR TYPE isbn USING hash FAMILY isn_ops AS OPERATOR 1 =, FUNCTION 1 hashisbn(isbn); -- ISBN vs other types: CREATE FUNCTION btisbncmp(isbn, ean13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION btisbncmp(isbn, isbn13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; ALTER OPERATOR FAMILY isn_ops USING btree ADD OPERATOR 1 < (isbn, ean13), OPERATOR 1 < (isbn, isbn13), OPERATOR 2 <= (isbn, ean13), OPERATOR 2 <= (isbn, isbn13), OPERATOR 3 = (isbn, ean13), OPERATOR 3 = (isbn, isbn13), OPERATOR 4 >= (isbn, ean13), OPERATOR 4 >= (isbn, isbn13), OPERATOR 5 > (isbn, ean13), OPERATOR 5 > (isbn, isbn13), FUNCTION 1 btisbncmp(isbn, ean13), FUNCTION 1 btisbncmp(isbn, isbn13); ALTER OPERATOR FAMILY isn_ops USING hash ADD OPERATOR 1 = (isbn, ean13), OPERATOR 1 = (isbn, isbn13); --------------------------------------------------- -- ISMN13: CREATE FUNCTION btismn13cmp(ismn13, ismn13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS ismn13_ops DEFAULT FOR TYPE ismn13 USING btree FAMILY isn_ops AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 btismn13cmp(ismn13, ismn13); CREATE FUNCTION hashismn13(ismn13) RETURNS int4 AS 'hashint8' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS ismn13_ops DEFAULT FOR TYPE ismn13 USING hash FAMILY isn_ops AS OPERATOR 1 =, FUNCTION 1 hashismn13(ismn13); -- ISMN13 vs other types: CREATE FUNCTION btismn13cmp(ismn13, ean13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION btismn13cmp(ismn13, ismn) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; ALTER OPERATOR FAMILY isn_ops USING btree ADD OPERATOR 1 < (ismn13, ean13), OPERATOR 1 < (ismn13, ismn), OPERATOR 2 <= (ismn13, ean13), OPERATOR 2 <= (ismn13, ismn), OPERATOR 3 = (ismn13, ean13), OPERATOR 3 = (ismn13, ismn), OPERATOR 4 >= (ismn13, ean13), OPERATOR 4 >= (ismn13, ismn), OPERATOR 5 > (ismn13, ean13), OPERATOR 5 > (ismn13, ismn), FUNCTION 1 btismn13cmp(ismn13, ean13), FUNCTION 1 btismn13cmp(ismn13, ismn); ALTER OPERATOR FAMILY isn_ops USING hash ADD OPERATOR 1 = (ismn13, ean13), OPERATOR 1 = (ismn13, ismn); --------------------------------------------------- -- ISMN: CREATE FUNCTION btismncmp(ismn, ismn) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS ismn_ops DEFAULT FOR TYPE ismn USING btree FAMILY isn_ops AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 btismncmp(ismn, ismn); CREATE FUNCTION hashismn(ismn) RETURNS int4 AS 'hashint8' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS ismn_ops DEFAULT FOR TYPE ismn USING hash FAMILY isn_ops AS OPERATOR 1 =, FUNCTION 1 hashismn(ismn); -- ISMN vs other types: CREATE FUNCTION btismncmp(ismn, ean13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION btismncmp(ismn, ismn13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; ALTER OPERATOR FAMILY isn_ops USING btree ADD OPERATOR 1 < (ismn, ean13), OPERATOR 1 < (ismn, ismn13), OPERATOR 2 <= (ismn, ean13), OPERATOR 2 <= (ismn, ismn13), OPERATOR 3 = (ismn, ean13), OPERATOR 3 = (ismn, ismn13), OPERATOR 4 >= (ismn, ean13), OPERATOR 4 >= (ismn, ismn13), OPERATOR 5 > (ismn, ean13), OPERATOR 5 > (ismn, ismn13), FUNCTION 1 btismncmp(ismn, ean13), FUNCTION 1 btismncmp(ismn, ismn13); ALTER OPERATOR FAMILY isn_ops USING hash ADD OPERATOR 1 = (ismn, ean13), OPERATOR 1 = (ismn, ismn13); --------------------------------------------------- -- ISSN13: CREATE FUNCTION btissn13cmp(issn13, issn13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS issn13_ops DEFAULT FOR TYPE issn13 USING btree FAMILY isn_ops AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 btissn13cmp(issn13, issn13); CREATE FUNCTION hashissn13(issn13) RETURNS int4 AS 'hashint8' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS issn13_ops DEFAULT FOR TYPE issn13 USING hash FAMILY isn_ops AS OPERATOR 1 =, FUNCTION 1 hashissn13(issn13); -- ISSN13 vs other types: CREATE FUNCTION btissn13cmp(issn13, ean13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION btissn13cmp(issn13, issn) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; ALTER OPERATOR FAMILY isn_ops USING btree ADD OPERATOR 1 < (issn13, ean13), OPERATOR 1 < (issn13, issn), OPERATOR 2 <= (issn13, ean13), OPERATOR 2 <= (issn13, issn), OPERATOR 3 = (issn13, ean13), OPERATOR 3 = (issn13, issn), OPERATOR 4 >= (issn13, ean13), OPERATOR 4 >= (issn13, issn), OPERATOR 5 > (issn13, ean13), OPERATOR 5 > (issn13, issn), FUNCTION 1 btissn13cmp(issn13, ean13), FUNCTION 1 btissn13cmp(issn13, issn); ALTER OPERATOR FAMILY isn_ops USING hash ADD OPERATOR 1 = (issn13, ean13), OPERATOR 1 = (issn13, issn); --------------------------------------------------- -- ISSN: CREATE FUNCTION btissncmp(issn, issn) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS issn_ops DEFAULT FOR TYPE issn USING btree FAMILY isn_ops AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 btissncmp(issn, issn); CREATE FUNCTION hashissn(issn) RETURNS int4 AS 'hashint8' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS issn_ops DEFAULT FOR TYPE issn USING hash FAMILY isn_ops AS OPERATOR 1 =, FUNCTION 1 hashissn(issn); -- ISSN vs other types: CREATE FUNCTION btissncmp(issn, ean13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION btissncmp(issn, issn13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; ALTER OPERATOR FAMILY isn_ops USING btree ADD OPERATOR 1 < (issn, ean13), OPERATOR 1 < (issn, issn13), OPERATOR 2 <= (issn, ean13), OPERATOR 2 <= (issn, issn13), OPERATOR 3 = (issn, ean13), OPERATOR 3 = (issn, issn13), OPERATOR 4 >= (issn, ean13), OPERATOR 4 >= (issn, issn13), OPERATOR 5 > (issn, ean13), OPERATOR 5 > (issn, issn13), FUNCTION 1 btissncmp(issn, ean13), FUNCTION 1 btissncmp(issn, issn13); ALTER OPERATOR FAMILY isn_ops USING hash ADD OPERATOR 1 = (issn, ean13), OPERATOR 1 = (issn, issn13); --------------------------------------------------- -- UPC: CREATE FUNCTION btupccmp(upc, upc) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS upc_ops DEFAULT FOR TYPE upc USING btree FAMILY isn_ops AS OPERATOR 1 <, OPERATOR 2 <=, OPERATOR 3 =, OPERATOR 4 >=, OPERATOR 5 >, FUNCTION 1 btupccmp(upc, upc); CREATE FUNCTION hashupc(upc) RETURNS int4 AS 'hashint8' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; CREATE OPERATOR CLASS upc_ops DEFAULT FOR TYPE upc USING hash FAMILY isn_ops AS OPERATOR 1 =, FUNCTION 1 hashupc(upc); -- UPC vs other types: CREATE FUNCTION btupccmp(upc, ean13) RETURNS int4 AS 'btint8cmp' LANGUAGE 'internal' IMMUTABLE STRICT PARALLEL SAFE; ALTER OPERATOR FAMILY isn_ops USING btree ADD OPERATOR 1 < (upc, ean13), OPERATOR 2 <= (upc, ean13), OPERATOR 3 = (upc, ean13), OPERATOR 4 >= (upc, ean13), OPERATOR 5 > (upc, ean13), FUNCTION 1 btupccmp(upc, ean13); ALTER OPERATOR FAMILY isn_ops USING hash ADD OPERATOR 1 = (upc, ean13); -- -- Type casts: -- --------------------------------------------------- CREATE FUNCTION isbn13(ean13) RETURNS isbn13 AS 'MODULE_PATHNAME', 'isbn_cast_from_ean13' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION ismn13(ean13) RETURNS ismn13 AS 'MODULE_PATHNAME', 'ismn_cast_from_ean13' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION issn13(ean13) RETURNS issn13 AS 'MODULE_PATHNAME', 'issn_cast_from_ean13' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION isbn(ean13) RETURNS isbn AS 'MODULE_PATHNAME', 'isbn_cast_from_ean13' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION ismn(ean13) RETURNS ismn AS 'MODULE_PATHNAME', 'ismn_cast_from_ean13' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION issn(ean13) RETURNS issn AS 'MODULE_PATHNAME', 'issn_cast_from_ean13' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION upc(ean13) RETURNS upc AS 'MODULE_PATHNAME', 'upc_cast_from_ean13' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE CAST (ean13 AS isbn13) WITH FUNCTION isbn13(ean13); CREATE CAST (ean13 AS isbn) WITH FUNCTION isbn(ean13); CREATE CAST (ean13 AS ismn13) WITH FUNCTION ismn13(ean13); CREATE CAST (ean13 AS ismn) WITH FUNCTION ismn(ean13); CREATE CAST (ean13 AS issn13) WITH FUNCTION issn13(ean13); CREATE CAST (ean13 AS issn) WITH FUNCTION issn(ean13); CREATE CAST (ean13 AS upc) WITH FUNCTION upc(ean13); CREATE CAST (isbn13 AS ean13) WITHOUT FUNCTION AS ASSIGNMENT; CREATE CAST (isbn AS ean13) WITHOUT FUNCTION AS ASSIGNMENT; CREATE CAST (ismn13 AS ean13) WITHOUT FUNCTION AS ASSIGNMENT; CREATE CAST (ismn AS ean13) WITHOUT FUNCTION AS ASSIGNMENT; CREATE CAST (issn13 AS ean13) WITHOUT FUNCTION AS ASSIGNMENT; CREATE CAST (issn AS ean13) WITHOUT FUNCTION AS ASSIGNMENT; CREATE CAST (upc AS ean13) WITHOUT FUNCTION AS ASSIGNMENT; CREATE CAST (isbn AS isbn13) WITHOUT FUNCTION AS ASSIGNMENT; CREATE CAST (isbn13 AS isbn) WITHOUT FUNCTION AS ASSIGNMENT; CREATE CAST (ismn AS ismn13) WITHOUT FUNCTION AS ASSIGNMENT; CREATE CAST (ismn13 AS ismn) WITHOUT FUNCTION AS ASSIGNMENT; CREATE CAST (issn AS issn13) WITHOUT FUNCTION AS ASSIGNMENT; CREATE CAST (issn13 AS issn) WITHOUT FUNCTION AS ASSIGNMENT; -- -- Validation stuff for lose types: -- CREATE FUNCTION make_valid(ean13) RETURNS ean13 AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION make_valid(isbn13) RETURNS isbn13 AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION make_valid(ismn13) RETURNS ismn13 AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION make_valid(issn13) RETURNS issn13 AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION make_valid(isbn) RETURNS isbn AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION make_valid(ismn) RETURNS ismn AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION make_valid(issn) RETURNS issn AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION make_valid(upc) RETURNS upc AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION is_valid(ean13) RETURNS boolean AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION is_valid(isbn13) RETURNS boolean AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION is_valid(ismn13) RETURNS boolean AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION is_valid(issn13) RETURNS boolean AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION is_valid(isbn) RETURNS boolean AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION is_valid(ismn) RETURNS boolean AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION is_valid(issn) RETURNS boolean AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; CREATE FUNCTION is_valid(upc) RETURNS boolean AS 'MODULE_PATHNAME' LANGUAGE C IMMUTABLE STRICT PARALLEL SAFE; -- -- isn_weak(boolean) - Sets the weak input mode. -- This function is intended for testing use only! -- CREATE FUNCTION isn_weak(boolean) RETURNS boolean AS 'MODULE_PATHNAME', 'accept_weak_input' LANGUAGE C IMMUTABLE STRICT PARALLEL RESTRICTED; -- -- isn_weak() - Gets the weak input mode status -- CREATE FUNCTION isn_weak() RETURNS boolean AS 'MODULE_PATHNAME', 'weak_input_status' LANGUAGE C IMMUTABLE STRICT PARALLEL RESTRICTED;
Submit
FILE
FOLDER
Name
Size
Permission
Action
adminpack--1.0--1.1.sql
274 bytes
0644
adminpack--1.0.sql
1535 bytes
0644
adminpack--1.1--2.0.sql
1682 bytes
0644
adminpack--2.0--2.1.sql
595 bytes
0644
adminpack.control
176 bytes
0644
amcheck--1.0--1.1.sql
931 bytes
0644
amcheck--1.0.sql
704 bytes
0644
amcheck--1.1--1.2.sql
705 bytes
0644
amcheck.control
154 bytes
0644
autoinc--1.0.sql
249 bytes
0644
autoinc.control
149 bytes
0644
bloom--1.0.sql
666 bytes
0644
bloom.control
156 bytes
0644
btree_gin--1.0--1.1.sql
1372 bytes
0644
btree_gin--1.0.sql
24818 bytes
0644
btree_gin--1.1--1.2.sql
1445 bytes
0644
btree_gin--1.2--1.3.sql
4571 bytes
0644
btree_gin.control
175 bytes
0644
btree_gist--1.0--1.1.sql
3739 bytes
0644
btree_gist--1.1--1.2.sql
5048 bytes
0644
btree_gist--1.2--1.3.sql
1955 bytes
0644
btree_gist--1.2.sql
41115 bytes
0644
btree_gist--1.3--1.4.sql
1932 bytes
0644
btree_gist--1.4--1.5.sql
1872 bytes
0644
btree_gist.control
178 bytes
0644
citext--1.0--1.1.sql
1028 bytes
0644
citext--1.1--1.2.sql
3424 bytes
0644
citext--1.2--1.3.sql
850 bytes
0644
citext--1.3--1.4.sql
668 bytes
0644
citext--1.4--1.5.sql
2284 bytes
0644
citext--1.4.sql
13466 bytes
0644
citext--1.5--1.6.sql
427 bytes
0644
citext.control
173 bytes
0644
cube--1.0--1.1.sql
1594 bytes
0644
cube--1.1--1.2.sql
3815 bytes
0644
cube--1.2--1.3.sql
365 bytes
0644
cube--1.2.sql
9761 bytes
0644
cube--1.3--1.4.sql
2387 bytes
0644
cube.control
157 bytes
0644
dblink--1.0--1.1.sql
419 bytes
0644
dblink--1.1--1.2.sql
2832 bytes
0644
dblink--1.2.sql
6645 bytes
0644
dblink.control
170 bytes
0644
dict_int--1.0.sql
711 bytes
0644
dict_int.control
173 bytes
0644
dict_xsyn--1.0.sql
694 bytes
0644
dict_xsyn.control
179 bytes
0644
earthdistance--1.0--1.1.sql
671 bytes
0644
earthdistance--1.1.sql
3234 bytes
0644
earthdistance.control
202 bytes
0644
file_fdw--1.0.sql
475 bytes
0644
file_fdw.control
155 bytes
0644
fuzzystrmatch--1.0--1.1.sql
788 bytes
0644
fuzzystrmatch--1.1.sql
1576 bytes
0644
fuzzystrmatch.control
190 bytes
0644
hstore--1.0--1.1.sql
279 bytes
0644
hstore--1.1--1.2.sql
1639 bytes
0644
hstore--1.2--1.3.sql
525 bytes
0644
hstore--1.3--1.4.sql
5310 bytes
0644
hstore--1.4--1.5.sql
409 bytes
0644
hstore--1.4.sql
13765 bytes
0644
hstore--1.5--1.6.sql
455 bytes
0644
hstore--1.6--1.7.sql
1061 bytes
0644
hstore.control
173 bytes
0644
hstore_plperl--1.0.sql
580 bytes
0644
hstore_plperl.control
186 bytes
0644
hstore_plperlu--1.0.sql
627 bytes
0644
hstore_plperlu.control
189 bytes
0644
hstore_plpython3u--1.0.sql
750 bytes
0644
hstore_plpython3u.control
201 bytes
0644
insert_username--1.0.sql
273 bytes
0644
insert_username.control
170 bytes
0644
intagg--1.0--1.1.sql
897 bytes
0644
intagg--1.1.sql
1089 bytes
0644
intagg.control
119 bytes
0644
intarray--1.0--1.1.sql
1794 bytes
0644
intarray--1.1--1.2.sql
5525 bytes
0644
intarray--1.2--1.3.sql
663 bytes
0644
intarray--1.2.sql
12293 bytes
0644
intarray.control
191 bytes
0644
isn--1.0--1.1.sql
12333 bytes
0644
isn--1.1--1.2.sql
5264 bytes
0644
isn--1.1.sql
69885 bytes
0644
isn.control
175 bytes
0644
jsonb_plperl--1.0.sql
658 bytes
0644
jsonb_plperl.control
191 bytes
0644
jsonb_plperlu--1.0.sql
704 bytes
0644
jsonb_plperlu.control
178 bytes
0644
jsonb_plpython3u--1.0.sql
732 bytes
0644
jsonb_plpython3u.control
191 bytes
0644
lo--1.0--1.1.sql
223 bytes
0644
lo--1.1.sql
722 bytes
0644
lo.control
141 bytes
0644
ltree--1.0--1.1.sql
6336 bytes
0644
ltree--1.1--1.2.sql
5217 bytes
0644
ltree--1.1.sql
19375 bytes
0644
ltree.control
170 bytes
0644
ltree_plpython3u--1.0.sql
449 bytes
0644
ltree_plpython3u.control
197 bytes
0644
moddatetime--1.0.sql
261 bytes
0644
moddatetime.control
165 bytes
0644
pageinspect--1.0--1.1.sql
560 bytes
0644
pageinspect--1.1--1.2.sql
562 bytes
0644
pageinspect--1.2--1.3.sql
1946 bytes
0644
pageinspect--1.3--1.4.sql
2566 bytes
0644
pageinspect--1.4--1.5.sql
1347 bytes
0644
pageinspect--1.5--1.6.sql
2252 bytes
0644
pageinspect--1.5.sql
6262 bytes
0644
pageinspect--1.6--1.7.sql
698 bytes
0644
pageinspect--1.7--1.8.sql
1711 bytes
0644
pageinspect.control
173 bytes
0644
pg_buffercache--1.0--1.1.sql
508 bytes
0644
pg_buffercache--1.1--1.2.sql
271 bytes
0644
pg_buffercache--1.2--1.3.sql
328 bytes
0644
pg_buffercache--1.2.sql
794 bytes
0644
pg_buffercache.control
157 bytes
0644
pg_freespacemap--1.0--1.1.sql
335 bytes
0644
pg_freespacemap--1.1--1.2.sql
377 bytes
0644
pg_freespacemap--1.1.sql
899 bytes
0644
pg_freespacemap.control
160 bytes
0644
pg_prewarm--1.0--1.1.sql
281 bytes
0644
pg_prewarm--1.1--1.2.sql
458 bytes
0644
pg_prewarm--1.1.sql
475 bytes
0644
pg_prewarm.control
139 bytes
0644
pg_stat_statements--1.0--1.1.sql
1246 bytes
0644
pg_stat_statements--1.1--1.2.sql
1336 bytes
0644
pg_stat_statements--1.2--1.3.sql
1454 bytes
0644
pg_stat_statements--1.3--1.4.sql
345 bytes
0644
pg_stat_statements--1.4--1.5.sql
305 bytes
0644
pg_stat_statements--1.4.sql
1427 bytes
0644
pg_stat_statements--1.5--1.6.sql
376 bytes
0644
pg_stat_statements--1.6--1.7.sql
806 bytes
0644
pg_stat_statements--1.7--1.8.sql
1744 bytes
0644
pg_stat_statements.control
204 bytes
0644
pg_trgm--1.0--1.1.sql
536 bytes
0644
pg_trgm--1.1--1.2.sql
2192 bytes
0644
pg_trgm--1.2--1.3.sql
3498 bytes
0644
pg_trgm--1.3--1.4.sql
2045 bytes
0644
pg_trgm--1.3.sql
7942 bytes
0644
pg_trgm--1.4--1.5.sql
858 bytes
0644
pg_trgm.control
192 bytes
0644
pg_visibility--1.0--1.1.sql
883 bytes
0644
pg_visibility--1.1--1.2.sql
833 bytes
0644
pg_visibility--1.1.sql
2825 bytes
0644
pg_visibility.control
186 bytes
0644
pgcrypto--1.0--1.1.sql
307 bytes
0644
pgcrypto--1.1--1.2.sql
483 bytes
0644
pgcrypto--1.2--1.3.sql
2346 bytes
0644
pgcrypto--1.3.sql
5708 bytes
0644
pgcrypto.control
152 bytes
0644
pgrowlocks--1.0--1.1.sql
651 bytes
0644
pgrowlocks--1.1--1.2.sql
253 bytes
0644
pgrowlocks--1.2.sql
555 bytes
0644
pgrowlocks.control
152 bytes
0644
pgstattuple--1.0--1.1.sql
400 bytes
0644
pgstattuple--1.1--1.2.sql
1435 bytes
0644
pgstattuple--1.2--1.3.sql
1126 bytes
0644
pgstattuple--1.3--1.4.sql
623 bytes
0644
pgstattuple--1.4--1.5.sql
5506 bytes
0644
pgstattuple--1.4.sql
3764 bytes
0644
pgstattuple.control
147 bytes
0644
plpgsql--1.0.sql
658 bytes
0644
plpgsql.control
193 bytes
0644
postgres_fdw--1.0.sql
507 bytes
0644
postgres_fdw.control
172 bytes
0644
refint--1.0.sql
343 bytes
0644
refint.control
169 bytes
0644
seg--1.0--1.1.sql
3005 bytes
0644
seg--1.1--1.2.sql
360 bytes
0644
seg--1.1.sql
8142 bytes
0644
seg--1.2--1.3.sql
2344 bytes
0644
seg.control
187 bytes
0644
sslinfo--1.0--1.1.sql
375 bytes
0644
sslinfo--1.1--1.2.sql
746 bytes
0644
sslinfo--1.2.sql
1534 bytes
0644
sslinfo.control
146 bytes
0644
tablefunc--1.0.sql
2153 bytes
0644
tablefunc.control
189 bytes
0644
tcn--1.0.sql
274 bytes
0644
tcn.control
149 bytes
0644
tsm_system_rows--1.0.sql
327 bytes
0644
tsm_system_rows.control
201 bytes
0644
tsm_system_time--1.0.sql
327 bytes
0644
tsm_system_time.control
207 bytes
0644
unaccent--1.0--1.1.sql
445 bytes
0644
unaccent--1.1.sql
910 bytes
0644
unaccent.control
172 bytes
0644
uuid-ossp--1.0--1.1.sql
688 bytes
0644
uuid-ossp--1.1.sql
1516 bytes
0644
uuid-ossp.control
178 bytes
0644
xml2--1.0--1.1.sql
944 bytes
0644
xml2--1.1.sql
2049 bytes
0644
xml2.control
182 bytes
0644
N4ST4R_ID | Naxtarrr