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.
It isn't very helpful to return the word NULL in many cases, since the
WHERE clause "col = NULL" does not do the same thing as "col is NULL".
So you need to know about NULL values and how to handle them in many
cases.
It might be useful to define a new text concatenation operator ||| that
treats NULL values as zero-length strings, so that 'help ' ||| NULL ||| 'me' returns 'help me'
-- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com