Scott Marlowe <[email protected]> writes:
> On Mon, Jun 15, 2009 at 11:35 AM, Gurjeet Singh<[email protected]>
> wrote:
>> On Mon, Jun 15, 2009 at 10:57 PM, Scott Marlowe <[email protected]>
>> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
