Sophie

Sophie

distrib > Mandriva > 2006.0 > x86_64 > by-pkgid > 4de08fd6a3c34e8b23cc690a0ef30243 > files > 47

postgresql-contrib-8.0.11-0.1.20060mdk.x86_64.rpm

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