>>> On Wed, Oct 10, 2007 at 4:57 AM, in message
<[EMAIL PROTECTED]>, "Brendan Jurd"
<[EMAIL PROTECTED]> wrote:
> On 10/10/07, Simon Riggs <[EMAIL PROTECTED]> wrote:
>> On Wed, 2007-10-10 at 14:57 +1000, Brendan Jurd wrote:
>>
>> > Wouldn't it be more useful if quote_literal(NULL) yielded the text value
> 'NULL'?
>>
>> I don't think you can change that now. There could be code out there
>> that relies on that behaviour.
>>
>
> Bummer. But I take your point. If there's a good chance someone is
> going to have their application murdered by a change here, best to
> leave it alone.
In particular, it seems like exactly what you would want for values
you're going to use in an INSERT or the SET clause of an UPDATE.
-Kevin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
