Ivan Sergio Borgonovo <mail(at)webthatworks(dot)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
In response to
pgsql-general by date
|Next:||From: Amit Phatarphekar||Date: 2008-03-31 02:25:48|
|Subject: Logging/Viewing parameters of a prepared statement|
|Previous:||From: Dragan Zubac||Date: 2008-03-30 23:19:34|
|Subject: Re: database 1.2G, pg_dump 73M?!|