11--
22--PostgreSQL code for ISSNs.
33--
4- --$PostgreSQL: pgsql/contrib/isbn_issn/isbn_issn.sql.in,v 1.10 2003/11 /29 22:39:20 pgsql Exp $
4+ --$PostgreSQL: pgsql/contrib/isbn_issn/isbn_issn.sql.in,v 1.11 2005/01 /29 22:35:02 tgl Exp $
55--
66
77-- Adjust this setting to control where the objects get created.
@@ -14,12 +14,12 @@ SET search_path = public;
1414CREATE FUNCTION issn_in(cstring)
1515RETURNS issn
1616AS 'MODULE_PATHNAME'
17- LANGUAGE'C' ;
17+ LANGUAGEC STRICT ;
1818
1919CREATE FUNCTION issn_out(issn)
2020RETURNS cstring
2121AS 'MODULE_PATHNAME'
22- LANGUAGE'C' ;
22+ LANGUAGEC STRICT ;
2323
2424CREATE TYPE issn (
2525INTERNALLENGTH = 16,
@@ -39,32 +39,32 @@ COMMENT ON TYPE issn
3939CREATE FUNCTION issn_lt(issn, issn)
4040RETURNS bool
4141AS 'MODULE_PATHNAME'
42- LANGUAGE'C' ;
42+ LANGUAGEC STRICT ;
4343
4444CREATE FUNCTION issn_le(issn, issn)
4545RETURNS bool
4646AS 'MODULE_PATHNAME'
47- LANGUAGE'C' ;
47+ LANGUAGEC STRICT ;
4848
4949CREATE FUNCTION issn_eq(issn, issn)
5050RETURNS bool
5151AS 'MODULE_PATHNAME'
52- LANGUAGE'C' ;
52+ LANGUAGEC STRICT ;
5353
5454CREATE FUNCTION issn_ge(issn, issn)
5555RETURNS bool
5656AS 'MODULE_PATHNAME'
57- LANGUAGE'C' ;
57+ LANGUAGEC STRICT ;
5858
5959CREATE FUNCTION issn_gt(issn, issn)
6060RETURNS bool
6161AS 'MODULE_PATHNAME'
62- LANGUAGE'C' ;
62+ LANGUAGEC STRICT ;
6363
6464CREATE FUNCTION issn_ne(issn, issn)
6565RETURNS bool
6666AS 'MODULE_PATHNAME'
67- LANGUAGE'C' ;
67+ LANGUAGEC STRICT ;
6868
6969--
7070--Now the operators. Note how some of the parameters to some
@@ -120,7 +120,7 @@ CREATE OPERATOR <> (
120120CREATE FUNCTION issn_cmp(issn, issn)
121121RETURNS integer
122122AS '$libdir/isbn_issn'
123- LANGUAGE c;
123+ LANGUAGE c STRICT ;
124124
125125-- Create default operator class for 'issn' --
126126-- Needed to create index or primary key --
147147CREATE FUNCTION isbn_in(cstring)
148148RETURNS isbn
149149AS 'MODULE_PATHNAME'
150- LANGUAGE'C' ;
150+ LANGUAGEC STRICT ;
151151
152152CREATE FUNCTION isbn_out(isbn)
153153RETURNS cstring
154154AS 'MODULE_PATHNAME'
155- LANGUAGE'C' ;
155+ LANGUAGEC STRICT ;
156156
157157CREATE TYPE isbn (
158158INTERNALLENGTH = 16,
@@ -171,32 +171,32 @@ COMMENT ON TYPE isbn IS 'International Standard Book Number';
171171CREATE FUNCTION isbn_lt(isbn, isbn)
172172RETURNS bool
173173AS 'MODULE_PATHNAME'
174- LANGUAGE'C' ;
174+ LANGUAGEC STRICT ;
175175
176176CREATE FUNCTION isbn_le(isbn, isbn)
177177RETURNS bool
178178AS 'MODULE_PATHNAME'
179- LANGUAGE'C' ;
179+ LANGUAGEC STRICT ;
180180
181181CREATE FUNCTION isbn_eq(isbn, isbn)
182182RETURNS bool
183183AS 'MODULE_PATHNAME'
184- LANGUAGE'C' ;
184+ LANGUAGEC STRICT ;
185185
186186CREATE FUNCTION isbn_ge(isbn, isbn)
187187RETURNS bool
188188AS 'MODULE_PATHNAME'
189- LANGUAGE'C' ;
189+ LANGUAGEC STRICT ;
190190
191191CREATE FUNCTION isbn_gt(isbn, isbn)
192192RETURNS bool
193193AS 'MODULE_PATHNAME'
194- LANGUAGE'C' ;
194+ LANGUAGEC STRICT ;
195195
196196CREATE FUNCTION isbn_ne(isbn, isbn)
197197RETURNS bool
198198AS 'MODULE_PATHNAME'
199- LANGUAGE'C' ;
199+ LANGUAGEC STRICT ;
200200
201201--
202202--Now the operators. Note how some of the parameters to some
@@ -253,7 +253,7 @@ CREATE OPERATOR <> (
253253CREATE FUNCTION isbn_cmp(isbn, isbn)
254254RETURNS integer
255255AS '$libdir/isbn_issn'
256- LANGUAGE c;
256+ LANGUAGE c STRICT ;
257257
258258-- Create default operator class for 'isbn' --
259259-- Needed to create index or primary key --