aboutsummaryrefslogtreecommitdiff
path: root/contrib/array/README.array_iterator
diff options
context:
space:
mode:
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