Re: Array Parameters in EXECUTE

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