Re: quote_literal with NULL - Mailing list pgsql-hackers

From Brendan Jurd
Subject Re: quote_literal with NULL
Date
Msg-id 37ed240d0710110110w2bceab9cybc19b117278f5c7@mail.gmail.com
Whole thread Raw
In response to Re: quote_literal with NULL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 10/11/07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Well, it's clearly useful in INSERT and UPDATE.  For WHERE cases, you
> might or might not be able to use it, but I note that quote_nullable()
> would work much more like what happens if you use a parameter symbol
> and then bind NULL as the actual parameter value ...
>
> In hindsight we should probably have done quote_literal the way the OP
> suggests, but I concur that it's too late to change it.  An additional
> function seems a reasonable compromise.

quote_nullable() works for me.  I'll write up a patch.

Cheers,
BJ


pgsql-hackers by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: Plan invalidation vs temp sequences
Next
From: Gregory Stark
Date:
Subject: Re: Plan invalidation vs temp sequences