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/array/README.array_iterator | |
parent | 4cc7a93d220644ae068ce2639b961db6764a68f6 (diff) | |
download | postgresql-d20763dbee7cdf8a700bf6bdd120b3913a3b99f4.tar.gz postgresql-d20763dbee7cdf8a700bf6bdd120b3913a3b99f4.zip |
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/array/README.array_iterator')
-rw-r--r-- | contrib/array/README.array_iterator | 31 |
1 files changed, 0 insertions, 31 deletions
diff --git a/contrib/array/README.array_iterator b/contrib/array/README.array_iterator deleted file mode 100644 index 127a6f4ba94..00000000000 --- a/contrib/array/README.array_iterator +++ /dev/null @@ -1,31 +0,0 @@ -Array iterator functions have been removed as of PostgreSQL 7.4, because -equivalent functionality is now available built in to the backend. - -For example, previously, using contrib/array, you might have used the -following construct: - - create table t(id int4[], txt text[]); - - -- select tuples with some id element equal to 123 - select * from t where t.id *= 123; - -Now you would do this instead: - - -- select tuples with some id element equal to 123 - select * from t where 123 = any (t.id); - - -- or you could also do this - select * from t where 123 = some (t.id); - -Similarly, if using contrib/array, you did the following: - - -- select tuples with all txt elements matching '^[A-Z]' - select * from t where t.txt[1:3] **~ '^[A-Z]'; - -Now do this instead: - - -- select tuples with all txt elements matching '^[A-Z]' - select * from t where '^[A-Z]' ~ all (t.txt[1:3]); - -See this section in the PostgreSQL documentation for more detail: - The SQL Language => Functions and Operators => Row and Array Comparisons |