Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes:
> On Mon, Jun 15, 2009 at 11:35 AM, Gurjeet Singh<singh(dot)gurjeet(at)gmail(dot)com> wrote:
>> On Mon, Jun 15, 2009 at 10:57 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
>>> 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
In response to
pgsql-admin by date
|Next:||From: Igor Polishchuk||Date: 2009-06-15 20:15:30|
|Subject: Is IDLE session really idle?|
|Previous:||From: Scott Marlowe||Date: 2009-06-15 18:32:09|
|Subject: Re: partition insert performance|