diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-06-22 22:56:29 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-06-22 22:56:29 +0000 |
commit | d20763dbee7cdf8a700bf6bdd120b3913a3b99f4 (patch) | |
tree | 5cb9ed9ba10cdbac226fd6b96ac02a2cc5a543a8 /contrib/string/string_io.sql.in | |
parent | 4cc7a93d220644ae068ce2639b961db6764a68f6 (diff) |
Remove contrib modules that have been agreed to be obsolete.
(There are more that will be removed once they've been copied to
pgfoundry.org.)
Diffstat (limited to 'contrib/string/string_io.sql.in')
-rw-r--r-- | contrib/string/string_io.sql.in | 84 |
1 files changed, 0 insertions, 84 deletions
diff --git a/contrib/string/string_io.sql.in b/contrib/string/string_io.sql.in deleted file mode 100644 index 392cda2ee78..00000000000 --- a/contrib/string/string_io.sql.in +++ /dev/null @@ -1,84 +0,0 @@ --- string_io.sql -- --- --- SQL code to define the new string I/O functions --- --- Copyright (c) 1998, Massimo Dal Zotto <dz@cs.unitn.it> --- --- This file is distributed under the GNU General Public License --- either version 2, or (at your option) any later version. - --- Define the new output functions. --- -CREATE FUNCTION c_charout(bpchar) -RETURNS cstring -AS 'MODULE_PATHNAME' -LANGUAGE 'C'; - -CREATE FUNCTION c_textout(text) -RETURNS cstring -AS 'MODULE_PATHNAME' -LANGUAGE 'C'; - -CREATE FUNCTION c_varcharout(varchar) -RETURNS cstring -AS 'MODULE_PATHNAME' -LANGUAGE 'C'; - --- This is not needed because escapes are handled by the parser --- --- CREATE FUNCTION c_textin(cstring) --- RETURNS text --- AS 'MODULE_PATHNAME' --- LANGUAGE 'c'; - --- Define a function which sets the new output routines for char types. --- --- SELECT c_mode(); --- -CREATE FUNCTION c_mode() -RETURNS text -AS ' UPDATE pg_type SET typoutput=''c_textout'' WHERE typname=''SET''; - UPDATE pg_type SET typoutput=''c_varcharout'' WHERE typname=''bpchar''; - UPDATE pg_type SET typoutput=''c_textout'' WHERE typname=''bytea''; - UPDATE pg_type SET typoutput=''c_charout'' WHERE typname=''char''; - UPDATE pg_type SET typoutput=''c_textout'' WHERE typname=''text''; - UPDATE pg_type SET typoutput=''c_textout'' WHERE typname=''unknown''; - UPDATE pg_type SET typoutput=''c_varcharout'' WHERE typname=''varchar''; - select ''c_mode''::text;' -LANGUAGE 'SQL'; - --- Define a function which restores the standard routines for char types. --- --- SELECT pg_mode(); --- -CREATE FUNCTION pg_mode() -RETURNS text -AS ' UPDATE pg_type SET typoutput=''textout'' WHERE typname=''SET''; - UPDATE pg_type SET typoutput=''varcharout'' WHERE typname=''bpchar''; - UPDATE pg_type SET typoutput=''textout'' WHERE typname=''bytea''; - UPDATE pg_type SET typoutput=''charout'' WHERE typname=''char''; - UPDATE pg_type SET typoutput=''textout'' WHERE typname=''text''; - UPDATE pg_type SET typoutput=''textout'' WHERE typname=''unknown''; - UPDATE pg_type SET typoutput=''varcharout'' WHERE typname=''varchar''; - select ''pg_mode''::text;' -LANGUAGE 'SQL'; - --- Use these to do the changes manually. --- --- UPDATE pg_type SET typoutput='textout' WHERE typname='SET'; --- UPDATE pg_type SET typoutput='varcharout' WHERE typname='bpchar'; --- UPDATE pg_type SET typoutput='textout' WHERE typname='bytea'; --- UPDATE pg_type SET typoutput='charout' WHERE typname='char'; --- UPDATE pg_type SET typoutput='textout' WHERE typname='text'; --- UPDATE pg_type SET typoutput='textout' WHERE typname='unknown'; --- UPDATE pg_type SET typoutput='varcharout' WHERE typname='varchar'; --- --- UPDATE pg_type SET typoutput='c_textout' WHERE typname='SET'; --- UPDATE pg_type SET typoutput='c_varcharout' WHERE typname='bpchar'; --- UPDATE pg_type SET typoutput='c_textout' WHERE typname='bytea'; --- UPDATE pg_type SET typoutput='c_charout' WHERE typname='char'; --- UPDATE pg_type SET typoutput='c_textout' WHERE typname='text'; --- UPDATE pg_type SET typoutput='c_textout' WHERE typname='unknown'; --- UPDATE pg_type SET typoutput='c_varcharout' WHERE typname='varchar'; - --- end of file |