From 5b4b3d563d0db16a00909a64090efa877593cffd Mon Sep 17 00:00:00 2001
From: "Marc G. Fournier" <scrappy@hub.org>
Date: Wed, 22 Apr 1998 04:16:46 +0000
Subject: From: Jun Kuwamura <juk@rccm.co.jp>

  This patch fix the Makefiles in contrib/{pginterface, spi,
miscutil, int8, ip_and_mac, sequence, soundex, string, userlock,
array, datetime} to install their modules in one directory(lib/modules/).
---
 contrib/string/string_io.sql | 111 -------------------------------------------
 1 file changed, 111 deletions(-)
 delete mode 100644 contrib/string/string_io.sql

(limited to 'contrib/string/string_io.sql')

diff --git a/contrib/string/string_io.sql b/contrib/string/string_io.sql
deleted file mode 100644
index 011371707d5..00000000000
--- a/contrib/string/string_io.sql
+++ /dev/null
@@ -1,111 +0,0 @@
-
-- - -- load the new functions
-- - --
-load '/home/dz/lib/postgres/string_output.so';
-
-- - -- create function c_textin(opaque)
-- - --   returns text
-- - --   as '/home/dz/lib/postgres/string_output.so' 
-- - --   language 'c';
-
-create function c_charout(opaque)
-  returns int4
-  as '/home/dz/lib/postgres/string_output.so' 
-  language 'c';
-
-create function c_char2out(opaque)
-  returns int4
-  as '/home/dz/lib/postgres/string_output.so' 
-  language 'c';
-
-create function c_char4out(opaque)
-  returns int4
-  as '/home/dz/lib/postgres/string_output.so' 
-  language 'c';
-
-create function c_char8out(opaque)
-  returns int4
-  as '/home/dz/lib/postgres/string_output.so' 
-  language 'c';
-
-create function c_char16out(opaque)
-  returns int4
-  as '/home/dz/lib/postgres/string_output.so' 
-  language 'c';
-
-create function c_textout(opaque)
-  returns int4
-  as '/home/dz/lib/postgres/string_output.so' 
-  language 'c';
-
-create function c_varcharout(opaque)
-  returns int4
-  as '/home/dz/lib/postgres/string_output.so' 
-  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_charout''    where typname=''char''\;
-      update pg_type set typoutput=''c_char2out''   where typname=''char2''\;
-      update pg_type set typoutput=''c_char4out''   where typname=''char4''\;
-      update pg_type set typoutput=''c_char8out''   where typname=''char8''\;
-      update pg_type set typoutput=''c_char16out''  where typname=''char16''\;
-      update pg_type set typoutput=''c_textout''    where typname=''text''\;
-      update pg_type set typoutput=''c_textout''    where typname=''bytea''\;
-      update pg_type set typoutput=''c_textout''    where typname=''unknown''\;
-      update pg_type set typoutput=''c_textout''    where typname=''SET''\;
-      update pg_type set typoutput=''c_varcharout'' where typname=''varchar''\;
-      update pg_type set typoutput=''c_varcharout'' where typname=''bpchar''\;
-      select ''c_mode''::text'
-  language 'sql';
-
-- - -- define a function which restores the original routines for char types
-- - --
-- - --   select pg_mode();
-- - --
-create function pg_mode()
-  returns text
-  as 'update pg_type set typoutput=''charout''    where typname=''char''\;
-      update pg_type set typoutput=''char2out''   where typname=''char2''\;
-      update pg_type set typoutput=''char4out''   where typname=''char4''\;
-      update pg_type set typoutput=''char8out''   where typname=''char8''\;
-      update pg_type set typoutput=''char16out''  where typname=''char16''\;
-      update pg_type set typoutput=''textout''    where typname=''text''\;
-      update pg_type set typoutput=''textout''    where typname=''bytea''\;
-      update pg_type set typoutput=''textout''    where typname=''unknown''\;
-      update pg_type set typoutput=''textout''    where typname=''SET''\;
-      update pg_type set typoutput=''varcharout'' where typname=''varchar''\;
-      update pg_type set typoutput=''varcharout'' where typname=''bpchar''\;
-      select ''pg_mode''::text'
-  language 'sql';
-
-- - -- or do the changes manually
-- - --
-- - -- update pg_type set typoutput='charout'    where typname='char';
-- - -- update pg_type set typoutput='char2out'   where typname='char2';
-- - -- update pg_type set typoutput='char4out'   where typname='char4';
-- - -- update pg_type set typoutput='char8out'   where typname='char8';
-- - -- update pg_type set typoutput='char16out'  where typname='char16';
-- - -- update pg_type set typoutput='textout'    where typname='text';
-- - -- update pg_type set typoutput='textout'    where typname='bytea';
-- - -- update pg_type set typoutput='textout'    where typname='unknown';
-- - -- update pg_type set typoutput='textout'    where typname='SET';
-- - -- update pg_type set typoutput='varcharout' where typname='varchar';
-- - -- update pg_type set typoutput='varcharout' where typname='bpchar';
-- - --
-- - -- update pg_type set typoutput='c_charout'    where typname='char';
-- - -- update pg_type set typoutput='c_char2out'   where typname='char2';
-- - -- update pg_type set typoutput='c_char4out'   where typname='char4';
-- - -- update pg_type set typoutput='c_char8out'   where typname='char8';
-- - -- update pg_type set typoutput='c_char16out'  where typname='char16';
-- - -- update pg_type set typoutput='c_textout'    where typname='text';
-- - -- update pg_type set typoutput='c_textout'    where typname='bytea';
-- - -- update pg_type set typoutput='c_textout'    where typname='unknown';
-- - -- update pg_type set typoutput='c_textout'    where typname='SET';
-- - -- update pg_type set typoutput='c_varcharout' where typname='varchar';
-- - -- update pg_type set typoutput='c_varcharout' where typname='bpchar';
-
-- 
cgit v1.2.3

