Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general