diff options
Diffstat (limited to 'contrib')
-rw-r--r-- | contrib/isn/isn.sql.in | 34 |
1 files changed, 9 insertions, 25 deletions
diff --git a/contrib/isn/isn.sql.in b/contrib/isn/isn.sql.in index 48f14134af7..1963fbbee34 100644 --- a/contrib/isn/isn.sql.in +++ b/contrib/isn/isn.sql.in @@ -1,4 +1,4 @@ -/* $PostgreSQL: pgsql/contrib/isn/isn.sql.in,v 1.8 2007/11/13 04:24:28 momjian Exp $ */ +/* $PostgreSQL: pgsql/contrib/isn/isn.sql.in,v 1.9 2008/11/30 19:01:29 tgl Exp $ */ -- Adjust this setting to control where the objects get created. SET search_path = public; @@ -28,9 +28,7 @@ CREATE OR REPLACE FUNCTION ean13_out(ean13) CREATE TYPE ean13 ( INPUT = ean13_in, OUTPUT = ean13_out, - INTERNALLENGTH = 8, - ALIGNMENT = double, - STORAGE = PLAIN + LIKE = pg_catalog.int8 ); COMMENT ON TYPE ean13 IS 'International European Article Number (EAN13)'; @@ -48,9 +46,7 @@ CREATE OR REPLACE FUNCTION ean13_out(isbn13) CREATE TYPE isbn13 ( INPUT = isbn13_in, OUTPUT = ean13_out, - INTERNALLENGTH = 8, - ALIGNMENT = double, - STORAGE = PLAIN + LIKE = pg_catalog.int8 ); COMMENT ON TYPE isbn13 IS 'International Standard Book Number 13 (ISBN13)'; @@ -68,9 +64,7 @@ CREATE OR REPLACE FUNCTION ean13_out(ismn13) CREATE TYPE ismn13 ( INPUT = ismn13_in, OUTPUT = ean13_out, - INTERNALLENGTH = 8, - ALIGNMENT = double, - STORAGE = PLAIN + LIKE = pg_catalog.int8 ); COMMENT ON TYPE ismn13 IS 'International Standard Music Number 13 (ISMN13)'; @@ -88,9 +82,7 @@ CREATE OR REPLACE FUNCTION ean13_out(issn13) CREATE TYPE issn13 ( INPUT = issn13_in, OUTPUT = ean13_out, - INTERNALLENGTH = 8, - ALIGNMENT = double, - STORAGE = PLAIN + LIKE = pg_catalog.int8 ); COMMENT ON TYPE issn13 IS 'International Standard Serial Number 13 (ISSN13)'; @@ -110,9 +102,7 @@ CREATE OR REPLACE FUNCTION isn_out(isbn) CREATE TYPE isbn ( INPUT = isbn_in, OUTPUT = isn_out, - INTERNALLENGTH = 8, - ALIGNMENT = double, - STORAGE = PLAIN + LIKE = pg_catalog.int8 ); COMMENT ON TYPE isbn IS 'International Standard Book Number (ISBN)'; @@ -130,9 +120,7 @@ CREATE OR REPLACE FUNCTION isn_out(ismn) CREATE TYPE ismn ( INPUT = ismn_in, OUTPUT = isn_out, - INTERNALLENGTH = 8, - ALIGNMENT = double, - STORAGE = PLAIN + LIKE = pg_catalog.int8 ); COMMENT ON TYPE ismn IS 'International Standard Music Number (ISMN)'; @@ -150,9 +138,7 @@ CREATE OR REPLACE FUNCTION isn_out(issn) CREATE TYPE issn ( INPUT = issn_in, OUTPUT = isn_out, - INTERNALLENGTH = 8, - ALIGNMENT = double, - STORAGE = PLAIN + LIKE = pg_catalog.int8 ); COMMENT ON TYPE issn IS 'International Standard Serial Number (ISSN)'; @@ -170,9 +156,7 @@ CREATE OR REPLACE FUNCTION isn_out(upc) CREATE TYPE upc ( INPUT = upc_in, OUTPUT = isn_out, - INTERNALLENGTH = 8, - ALIGNMENT = double, - STORAGE = PLAIN + LIKE = pg_catalog.int8 ); COMMENT ON TYPE upc IS 'Universal Product Code (UPC)'; |