diff options
Diffstat (limited to 'contrib/array/array_iterator.sql.in')
| -rw-r--r-- | contrib/array/array_iterator.sql.in | 55 |
1 files changed, 12 insertions, 43 deletions
diff --git a/contrib/array/array_iterator.sql.in b/contrib/array/array_iterator.sql.in index 6489545d97d..40deb7e0c60 100644 --- a/contrib/array/array_iterator.sql.in +++ b/contrib/array/array_iterator.sql.in @@ -1,6 +1,13 @@ --- SQL code to define the new array iterator functions and operators +-- array_iterator.sql -- +-- +-- SQL code to define the array iterator functions and operators. +-- +-- 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 array operators *=, **=, *~ and **~ for type _text +-- Define the array functions *=, **=, *~ and **~ for type _text -- create function array_texteq(_text, text) returns bool as 'MODULE_PATHNAME' @@ -38,47 +45,7 @@ create operator **~ ( rightarg=text, procedure=array_all_textregexeq); - --- define the array operators *=, **=, *~ and **~ for type _char16 --- -create function array_char16eq(_char16, char16) returns bool - as 'MODULE_PATHNAME' - language 'c'; - -create function array_all_char16eq(_char16, char16) returns bool - as 'MODULE_PATHNAME' - language 'c'; - -create function array_char16regexeq(_char16, text) returns bool - as 'MODULE_PATHNAME' - language 'c'; - -create function array_all_char16regexeq(_char16, text) returns bool - as 'MODULE_PATHNAME' - 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 +-- Define the array functions *=, **=, *> and **> for type _int4 -- create function array_int4eq(_int4, int4) returns bool as 'MODULE_PATHNAME' @@ -128,6 +95,8 @@ create function array_all_int4le(_int4, int4) returns bool as 'MODULE_PATHNAME' language 'c'; +-- Define the operators corresponding to the above functions +-- create operator *= ( leftarg=_int4, rightarg=int4, |