Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes:
> for _row in
> select err, msg from errortable where err in (errcode)
> where errcode is an array.
> That syntax doesn't work...
In recent PG releases it will work as "WHERE err = ANY (errcode)"
but note that there is *no* guarantee that the select will deliver
the rows in the same order the array elements are in.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
