NEGATOR = =,	RESTRICT = neqsel,	JOIN = neqjoinsel);---- Operator classes:------------------------------------------------------- EAN13:CREATE FUNCTION btean13cmp(ean13, ean13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btean13cmp(ean13, isbn13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btean13cmp(ean13, ismn13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btean13cmp(ean13, issn13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btean13cmp(ean13, isbn)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btean13cmp(ean13, ismn)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btean13cmp(ean13, issn)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btean13cmp(ean13, upc)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE OPERATOR CLASS ean13_ops DEFAULT	FOR TYPE ean13 USING btree AS	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 1  <,	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 2  <=,	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 3  =,	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 4  >=,	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),	OPERATOR 5  >,	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),	FUNCTION 1  btean13cmp(ean13, ean13);CREATE FUNCTION hashean13(ean13)	RETURNS int4	AS 'hashint8'	LANGUAGE 'internal' IMMUTABLE STRICT;CREATE OPERATOR CLASS ean13_ops DEFAULT   FOR TYPE ean13 USING hash AS   OPERATOR 1  =,   FUNCTION 1  hashean13(ean13);----------------------------------------------------- ISBN13:CREATE FUNCTION btisbn13cmp(isbn13, isbn13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btisbn13cmp(isbn13, ean13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btisbn13cmp(isbn13, isbn)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE OPERATOR CLASS isbn13_ops DEFAULT	FOR TYPE isbn13 USING btree AS	OPERATOR 1  < (isbn13, ean13),	OPERATOR 1  < (isbn13, isbn),	OPERATOR 1  <,	OPERATOR 2  <= (isbn13, ean13),	OPERATOR 2  <= (isbn13, isbn),	OPERATOR 2  <=,	OPERATOR 3  = (isbn13, ean13), 	OPERATOR 3  = (isbn13, isbn),  	OPERATOR 3  =,	OPERATOR 4  >= (isbn13, ean13), 	OPERATOR 4  >= (isbn13, isbn),  	OPERATOR 4  >=,	OPERATOR 5  > (isbn13, ean13), 	OPERATOR 5  > (isbn13, isbn),  	OPERATOR 5  >,	FUNCTION 1  btisbn13cmp(isbn13, ean13),	FUNCTION 1  btisbn13cmp(isbn13, isbn),	FUNCTION 1  btisbn13cmp(isbn13, isbn13);CREATE FUNCTION hashisbn13(isbn13)	RETURNS int4	AS 'hashint8'	LANGUAGE 'internal' 	IMMUTABLE STRICT;CREATE OPERATOR CLASS isbn13_ops DEFAULT   FOR TYPE isbn13 USING hash AS   OPERATOR 1  =,   FUNCTION 1  hashisbn13(isbn13);----------------------------------------------------- ISBN:CREATE FUNCTION btisbncmp(isbn, isbn)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btisbncmp(isbn, ean13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btisbncmp(isbn, isbn13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE OPERATOR CLASS isbn_ops DEFAULT	FOR TYPE isbn USING btree AS	OPERATOR 1  < (isbn, ean13),	OPERATOR 1  < (isbn, isbn13),	OPERATOR 1  <,	OPERATOR 2  <= (isbn, ean13),  	OPERATOR 2  <= (isbn, isbn13), 	OPERATOR 2  <=,	OPERATOR 3  = (isbn, ean13),  	OPERATOR 3  = (isbn, isbn13), 	OPERATOR 3  =,	OPERATOR 4  >= (isbn, ean13),  	OPERATOR 4  >= (isbn, isbn13), 	OPERATOR 4  >=,	OPERATOR 5  > (isbn, ean13),  	OPERATOR 5  > (isbn, isbn13), 	OPERATOR 5  >,	FUNCTION 1  btisbncmp(isbn, ean13),	FUNCTION 1  btisbncmp(isbn, isbn13),	FUNCTION 1  btisbncmp(isbn, isbn);CREATE FUNCTION hashisbn(isbn)	RETURNS int4	AS 'hashint8'	LANGUAGE 'internal' 	IMMUTABLE STRICT;CREATE OPERATOR CLASS isbn_ops DEFAULT   FOR TYPE isbn USING hash AS   OPERATOR 1  =,   FUNCTION 1  hashisbn(isbn);----------------------------------------------------- ISMN13:CREATE FUNCTION btismn13cmp(ismn13, ismn13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btismn13cmp(ismn13, ean13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btismn13cmp(ismn13, ismn)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE OPERATOR CLASS ismn13_ops DEFAULT	FOR TYPE ismn13 USING btree AS	OPERATOR 1  < (ismn13, ean13),	OPERATOR 1  < (ismn13, ismn),	OPERATOR 1  <,	OPERATOR 2  <= (ismn13, ean13),	OPERATOR 2  <= (ismn13, ismn),	OPERATOR 2  <=,	OPERATOR 3  = (ismn13, ean13), 	OPERATOR 3  = (ismn13, ismn),  	OPERATOR 3  =,	OPERATOR 4  >= (ismn13, ean13), 	OPERATOR 4  >= (ismn13, ismn),  	OPERATOR 4  >=,	OPERATOR 5  > (ismn13, ean13), 	OPERATOR 5  > (ismn13, ismn),  	OPERATOR 5  >,	FUNCTION 1  btismn13cmp(ismn13, ean13),	FUNCTION 1  btismn13cmp(ismn13, ismn),	FUNCTION 1  btismn13cmp(ismn13, ismn13);CREATE FUNCTION hashismn13(ismn13)	RETURNS int4	AS 'hashint8'	LANGUAGE 'internal' 	IMMUTABLE STRICT;CREATE OPERATOR CLASS ismn13_ops DEFAULT   FOR TYPE ismn13 USING hash AS   OPERATOR 1  =,   FUNCTION 1  hashismn13(ismn13);----------------------------------------------------- ISMN:CREATE FUNCTION btismncmp(ismn, ismn)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btismncmp(ismn, ean13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btismncmp(ismn, ismn13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE OPERATOR CLASS ismn_ops DEFAULT	FOR TYPE ismn USING btree AS	OPERATOR 1  < (ismn, ean13),	OPERATOR 1  < (ismn, ismn13),	OPERATOR 1  <,	OPERATOR 2  <= (ismn, ean13),  	OPERATOR 2  <= (ismn, ismn13), 	OPERATOR 2  <=,	OPERATOR 3  = (ismn, ean13),  	OPERATOR 3  = (ismn, ismn13), 	OPERATOR 3  =,	OPERATOR 4  >= (ismn, ean13),  	OPERATOR 4  >= (ismn, ismn13), 	OPERATOR 4  >=,	OPERATOR 5  > (ismn, ean13),  	OPERATOR 5  > (ismn, ismn13), 	OPERATOR 5  >,	FUNCTION 1  btismncmp(ismn, ean13),	FUNCTION 1  btismncmp(ismn, ismn13),	FUNCTION 1  btismncmp(ismn, ismn);CREATE FUNCTION hashismn(ismn)	RETURNS int4	AS 'hashint8'	LANGUAGE 'internal' 	IMMUTABLE STRICT;CREATE OPERATOR CLASS ismn_ops DEFAULT   FOR TYPE ismn USING hash AS   OPERATOR 1  =,   FUNCTION 1  hashismn(ismn);----------------------------------------------------- ISSN13:CREATE FUNCTION btissn13cmp(issn13, issn13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btissn13cmp(issn13, ean13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btissn13cmp(issn13, issn)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE OPERATOR CLASS issn13_ops DEFAULT	FOR TYPE issn13 USING btree AS	OPERATOR 1  < (issn13, ean13),	OPERATOR 1  < (issn13, issn),	OPERATOR 1  <,	OPERATOR 2  <= (issn13, ean13),	OPERATOR 2  <= (issn13, issn),	OPERATOR 2  <=,	OPERATOR 3  = (issn13, ean13), 	OPERATOR 3  = (issn13, issn),  	OPERATOR 3  =,	OPERATOR 4  >= (issn13, ean13), 	OPERATOR 4  >= (issn13, issn),  	OPERATOR 4  >=,	OPERATOR 5  > (issn13, ean13), 	OPERATOR 5  > (issn13, issn),  	OPERATOR 5  >,	FUNCTION 1  btissn13cmp(issn13, ean13),	FUNCTION 1  btissn13cmp(issn13, issn),	FUNCTION 1  btissn13cmp(issn13, issn13);CREATE FUNCTION hashissn13(issn13)	RETURNS int4	AS 'hashint8'	LANGUAGE 'internal' 	IMMUTABLE STRICT;CREATE OPERATOR CLASS issn13_ops DEFAULT   FOR TYPE issn13 USING hash AS   OPERATOR 1  =,   FUNCTION 1  hashissn13(issn13);----------------------------------------------------- ISSN:CREATE FUNCTION btissncmp(issn, issn)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btissncmp(issn, ean13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btissncmp(issn, issn13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE OPERATOR CLASS issn_ops DEFAULT	FOR TYPE issn USING btree AS	OPERATOR 1  < (issn, ean13),	OPERATOR 1  < (issn, issn13),	OPERATOR 1  <,	OPERATOR 2  <= (issn, ean13),  	OPERATOR 2  <= (issn, issn13), 	OPERATOR 2  <=,	OPERATOR 3  = (issn, ean13),  	OPERATOR 3  = (issn, issn13), 	OPERATOR 3  =,	OPERATOR 4  >= (issn, ean13),  	OPERATOR 4  >= (issn, issn13), 	OPERATOR 4  >=,	OPERATOR 5  > (issn, ean13),  	OPERATOR 5  > (issn, issn13), 	OPERATOR 5  >,	FUNCTION 1  btissncmp(issn, ean13),	FUNCTION 1  btissncmp(issn, issn13),	FUNCTION 1  btissncmp(issn, issn);CREATE FUNCTION hashissn(issn)	RETURNS int4	AS 'hashint8'	LANGUAGE 'internal' 	IMMUTABLE STRICT;CREATE OPERATOR CLASS issn_ops DEFAULT   FOR TYPE issn USING hash AS   OPERATOR 1  =,   FUNCTION 1  hashissn(issn);----------------------------------------------------- UPC:CREATE FUNCTION btupccmp(upc, upc)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE FUNCTION btupccmp(upc, ean13)	RETURNS int4	AS 'btint8cmp'	LANGUAGE 'internal'	IMMUTABLE STRICT;CREATE OPERATOR CLASS upc_ops DEFAULT	FOR TYPE upc USING btree AS	OPERATOR 1  < (upc, ean13),	OPERATOR 1  <,	OPERATOR 2  <= (upc, ean13),  	OPERATOR 2  <=,	OPERATOR 3  = (upc, ean13),  	OPERATOR 3  =,	OPERATOR 4  >= (upc, ean13),  	OPERATOR 4  >=,	OPERATOR 5  > (upc, ean13),  	OPERATOR 5  >,	FUNCTION 1  btupccmp(upc, ean13),	FUNCTION 1  btupccmp(upc, upc);CREATE FUNCTION hashupc(upc)	RETURNS int4	AS 'hashint8'	LANGUAGE 'internal' 	IMMUTABLE STRICT;CREATE OPERATOR CLASS upc_ops DEFAULT   FOR TYPE upc USING hash AS   OPERATOR 1  =,   FUNCTION 1  hashupc(upc);---- Type casts:-----------------------------------------------------CREATE FUNCTION isbn13(ean13)RETURNS isbn13AS '$libdir/isn', 'isbn_cast_from_ean13'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION ismn13(ean13)RETURNS ismn13AS '$libdir/isn', 'ismn_cast_from_ean13'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION issn13(ean13)RETURNS issn13AS '$libdir/isn', 'issn_cast_from_ean13'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION isbn(ean13)RETURNS isbnAS '$libdir/isn', 'isbn_cast_from_ean13'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION ismn(ean13)RETURNS ismnAS '$libdir/isn', 'ismn_cast_from_ean13'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION issn(ean13)RETURNS issnAS '$libdir/isn', 'issn_cast_from_ean13'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION upc(ean13)RETURNS upcAS '$libdir/isn', 'upc_cast_from_ean13'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION ean13(text)RETURNS ean13AS '$libdir/isn', 'ean13_cast_from_text'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION isbn13(text)RETURNS isbn13AS '$libdir/isn', 'isbn_cast_from_text'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION ismn13(text)RETURNS ismn13AS '$libdir/isn', 'ismn_cast_from_text'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION issn13(text)RETURNS issn13AS '$libdir/isn', 'issn_cast_from_text'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION isbn(text)RETURNS isbnAS '$libdir/isn', 'isbn_cast_from_text'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION ismn(text)RETURNS ismnAS '$libdir/isn', 'ismn_cast_from_text'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION issn(text)RETURNS issnAS '$libdir/isn', 'issn_cast_from_text'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION upc(text)RETURNS upcAS '$libdir/isn', 'upc_cast_from_text'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION text(ean13)RETURNS textAS '$libdir/isn', 'ean13_cast_to_text'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION text(isbn13)RETURNS textAS '$libdir/isn', 'ean13_cast_to_text'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION text(ismn13)RETURNS textAS '$libdir/isn', 'ean13_cast_to_text'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION text(issn13)RETURNS textAS '$libdir/isn', 'ean13_cast_to_text'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION text(isbn)RETURNS textAS '$libdir/isn', 'isn_cast_to_text'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION text(ismn)RETURNS textAS '$libdir/isn', 'isn_cast_to_text'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION text(issn)RETURNS textAS '$libdir/isn', 'isn_cast_to_text'LANGUAGE 'C' IMMUTABLE STRICT;CREATE FUNCTION text(upc)RETURNS textAS '$libdir/isn', 'isn_cast_to_text'LANGUAGE 'C' IMMUTABLE STRICT;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;CREATE CAST (text AS ean13) WITH FUNCTION ean13(text);CREATE CAST (text AS isbn13) WITH FUNCTION isbn13(text);CREATE CAST (text AS ismn13) WITH FUNCTION ismn13(text);CREATE CAST (text AS issn13) WITH FUNCTION issn13(text);CREATE CAST (text AS isbn) WITH FUNCTION isbn(text);CREATE CAST (text AS ismn) WITH FUNCTION ismn(text);CREATE CAST (text AS issn) WITH FUNCTION issn(text);CREATE CAST (text AS upc) WITH FUNCTION upc(text);CREATE CAST (ean13 AS text) WITH FUNCTION text(ean13);CREATE CAST (isbn13 AS text) WITH FUNCTION text(isbn13);CREATE CAST (ismn13 AS text) WITH FUNCTION text(ismn13);CREATE CAST (issn13 AS text) WITH FUNCTION text(issn13);CREATE CAST (isbn AS text) WITH FUNCTION text(isbn);CREATE CAST (ismn AS text) WITH FUNCTION text(ismn);CREATE CAST (issn AS text) WITH FUNCTION text(issn);CREATE CAST (upc AS text) WITH FUNCTION text(upc);---- Validation stuff for lose types:--CREATE FUNCTION make_valid(ean13)	RETURNS ean13	AS '$libdir/isn'	LANGUAGE 'C'	IMMUTABLE STRICT;CREATE FUNCTION make_valid(isbn13)	RETURNS isbn13	AS '$libdir/isn'	LANGUAGE 'C'	IMMUTABLE STRICT;CREATE FUNCTION make_valid(ismn13)	RETURNS ismn13	AS '$libdir/isn'	LANGUAGE 'C'	IMMUTABLE STRICT;CREATE FUNCTION make_valid(issn13)	RETURNS issn13	AS '$libdir/isn'	LANGUAGE 'C'	IMMUTABLE STRICT;CREATE FUNCTION make_valid(isbn)	RETURNS isbn	AS '$libdir/isn'	LANGU