Re: shortcut for select * where id in (arrayvar)

Ivan Sergio Borgonovo <mail@webthatworks.it> 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