summaryrefslogtreecommitdiff
path: root/contrib/string/string_io.sql.in
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/string/string_io.sql.in')
-rw-r--r--contrib/string/string_io.sql.in79
1 files changed, 0 insertions, 79 deletions
diff --git a/contrib/string/string_io.sql.in b/contrib/string/string_io.sql.in
deleted file mode 100644
index 2a15e4b5354..00000000000
--- a/contrib/string/string_io.sql.in
+++ /dev/null
@@ -1,79 +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(opaque) returns int4
- as 'MODULE_PATHNAME'
- language 'c';
-
-create function c_textout(opaque) returns int4
- as 'MODULE_PATHNAME'
- language 'c';
-
-create function c_varcharout(opaque) returns int4
- as 'MODULE_PATHNAME'
- language 'c';
-
--- This is not needed because escapes are handled by the parser
---
--- create function c_textin(opaque)
--- 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