From d20763dbee7cdf8a700bf6bdd120b3913a3b99f4 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Wed, 22 Jun 2005 22:56:29 +0000 Subject: 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.) --- contrib/array/README.array_iterator | 31 ------------------------------- 1 file changed, 31 deletions(-) delete mode 100644 contrib/array/README.array_iterator (limited to 'contrib/array/README.array_iterator') 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 -- cgit v1.2.3