On Aug 23, 2007, at 1:27 PM, Tom Lane wrote:
Erik Jones <erik@xxxxxxxxxx> writes:
On Aug 23, 2007, at 11:56 AM, Gustavo Tonini wrote:
I want to create a function that receive a list argument and filter
data with IN operator. Example:
CREATE OR REPLACE FUNCTION public.ffoo(list sometype[]) RETURNS VOID
this is right ...
execute 'select * from foo where foo_column::text in (' ||
array_to_string(list, ',') || ');';
this is pretty horrid. Use = ANY(array) instead of trying to
construct
an IN on the fly.
select * from foo where foo_column = any(list)
Yes, I always forget about using ANY. Thx.
Erik Jones
Software Developer | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
