aboutsummaryrefslogtreecommitdiff
path: root/contrib/array/array_iterator.sql
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/array/array_iterator.sql')
-rw-r--r--contrib/array/array_iterator.sql137
1 files changed, 0 insertions, 137 deletions
diff --git a/contrib/array/array_iterator.sql b/contrib/array/array_iterator.sql
deleted file mode 100644
index 7a3356266c1..00000000000
--- a/contrib/array/array_iterator.sql
+++ /dev/null
@@ -1,137 +0,0 @@
-/*
- * SQL code
-
-- - -- load the new functions
-- - --
-load '/home/dz/lib/postgres/array_iterator.so';
-
-- - -- define the array operators *=, **=, *~ and **~ for type _text
-- - --
-create function array_texteq(_text, text)
- returns bool
- as '/home/dz/lib/postgres/array_iterator.so'
- language 'c';
-
-create function array_all_texteq(_text, text)
- returns bool
- as '/home/dz/lib/postgres/array_iterator.so'
- language 'c';
-
-create function array_textregexeq(_text, text)
- returns bool
- as '/home/dz/lib/postgres/array_iterator.so'
- language 'c';
-
-create function array_all_textregexeq(_text, text)
- returns bool
- as '/home/dz/lib/postgres/array_iterator.so'
- language 'c';
-
-create operator *= (
- leftarg=_text,
- rightarg=text,
- procedure=array_texteq);
-
-create operator **= (
- leftarg=_text,
- rightarg=text,
- procedure=array_all_texteq);
-
-create operator *~ (
- leftarg=_text,
- rightarg=text,
- procedure=array_textregexeq);
-
-create operator **~ (
- leftarg=_text,
- rightarg=text,
- procedure=array_all_textregexeq);
-
-- - -- define the array operators *=, **=, *~ and **~ for type _char16
-- - --
-create function array_char16eq(_char16, char16)
- returns bool
- as '/home/dz/lib/postgres/array_iterator.so'
- language 'c';
-
-create function array_all_char16eq(_char16, char16)
- returns bool
- as '/home/dz/lib/postgres/array_iterator.so'
- language 'c';
-
-create function array_char16regexeq(_char16, text)
- returns bool
- as '/home/dz/lib/postgres/array_iterator.so'
- language 'c';
-
-create function array_all_char16regexeq(_char16, text)
- returns bool
- as '/home/dz/lib/postgres/array_iterator.so'
- language 'c';
-
-create operator *= (
- leftarg=_char16,
- rightarg=char16,
- procedure=array_char16eq);
-
-create operator **= (
- leftarg=_char16,
- rightarg=char16,
- procedure=array_all_char16eq);
-
-create operator *~ (
- leftarg=_char16,
- rightarg=text,
- procedure=array_char16regexeq);
-
-create operator **~ (
- leftarg=_char16,
- rightarg=text,
- procedure=array_all_char16regexeq);
-
-- - -- define the array operators *=, **=, *> and **> for type _int4
-- - --
-create function array_int4eq(_int4, int4)
- returns bool
- as '/home/dz/lib/postgres/array_iterator.so'
- language 'c';
-
-create function array_all_int4eq(_int4, int4)
- returns bool
- as '/home/dz/lib/postgres/array_iterator.so'
- language 'c';
-
-create function array_int4gt(_int4, int4)
- returns bool
- as '/home/dz/lib/postgres/array_iterator.so'
- language 'c';
-
-create function array_all_int4gt(_int4, int4)
- returns bool
- as '/home/dz/lib/postgres/array_iterator.so'
- language 'c';
-
-create operator *= (
- leftarg=_int4,
- rightarg=int4,
- procedure=array_int4eq);
-
-create operator **= (
- leftarg=_int4,
- rightarg=int4,
- procedure=array_all_int4eq);
-
-create operator *> (
- leftarg=_int4,
- rightarg=int4,
- procedure=array_int4gt);
-
-create operator **> (
- leftarg=_int4,
- rightarg=int4,
- procedure=array_all_int4gt);
-
-*/
-
-/* end of file */
-