Postgres User wrote:
by the way, your example works fine unless it's a null value or empty string unfortunately, postgres isn't smart enough to know that the when p_param below is null, that the WHERE condition can be ignored select * from table where name in (Coalesce(p_param, name)) which is the same as: select * from table where name in (name) postgres does a row scan on the above sql. too slow.
If there's no where condition, postgres has to do a seq-scan anyway so your argument is void :)
-- Postgresql & php tutorials http://www.designmagick.com/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
