Re: help using arrays in a function - Mailing list pgsql-general

Jennifer Lee wrote:
>            WHILE a[i] LOOP

This problem has nothing to do with arrays, per se. PL/pgSQL no longer
assumes it can coerce an integer constant to a boolean. Instead make the
above line look like this:

              WHILE a[i] IS NOT NULL LOOP


BTW, in 7.4 you could more easily get the same result like this:

regression=# select 82 = any ('{100,92,82}');
  ?column?
----------
  t
(1 row)

regression=# select 82 = any ('{100,92}');
  ?column?
----------
  f
(1 row)

See:
http://www.postgresql.org/docs/current/static/functions-comparisons.html

HTH,

Joe