Ruben Gouveia wrote:
Is that more expensive to run than just useing a bunch of ticks?
Try wrapping your p_date in a quote_literal like ... 'where m.jb_date < '||quote_literal(p_date+INTEGER '1')||' and ...
I personally have never noticed any increased overhead from quote_literal. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
