Re added list!
--------------------------------------------------
Sent: Thursday, June 11, 2009 11:04 AM
To: "Shakil Shaikh" <>
Subject: Re: [GENERAL] Array Parameters in EXECUTE
Here's my general situation: I have a function which takes in an
optional ARRAY of Ids as so:
RETURN QUERY SELECT * FROM a WHERE a.id = ANY(v_ids) or v_ids is null;
However it seems that the ...or v_ids is null... bit forces a sequential
If I understand what you are trying to do, if your passed in parameter
is null then select * and if there is something there then check it.
I would put the statement in an if:
if v_ids is null then
RETURN QUERY select * from a;
else
return query SELECT * FROM a WHERE a.id = ANY(v_ids)
end if;
This works fine for the trivial case given but not for when there are
multiple optional array parameters (I know, I know...). I will probably use
branching for one or two parameters, but for three or four it might get a
bit cumbersome so I was wondering if there was a more general solution.
Shak
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general