> 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; > 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; It's definitely better then the loop. Sim -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
