diff options
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 |