aboutsummaryrefslogtreecommitdiff
path: root/contrib/array/README.array_iterator
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2005-06-22 22:56:29 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2005-06-22 22:56:29 +0000
commitd20763dbee7cdf8a700bf6bdd120b3913a3b99f4 (patch)
tree5cb9ed9ba10cdbac226fd6b96ac02a2cc5a543a8 /contrib/array/README.array_iterator
parent4cc7a93d220644ae068ce2639b961db6764a68f6 (diff)
downloadpostgresql-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_iterator31
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