Scott Marlowe <scott.marlowe@xxxxxxxxx> writes: > On Mon, Jun 15, 2009 at 11:35 AM, Gurjeet Singh<singh.gurjeet@xxxxxxxxx> wrote: >> On Mon, Jun 15, 2009 at 10:57 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> >> wrote: >>> If you're using plpgsql prepare for a world of pain if you've got any >>> null values in your inserts. >> >> :) Using COALESCE isn't that bad. > In my experience it's WAY more than just coalesce. quote_nullable() would really be the right thing for inserts. However, I think the short answer to the OP's question is that dynamic SQL will lose big-time performancewise. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
