Re: quote_literal with NULL - Mailing list pgsql-hackers

On Oct 10, 2007, at 11:24 , Greg Sabino Mullane wrote:

> (Aside: seems to me that
> SET foo = NULL; really should be SET foo TO NULL; to be consistent
> with WHERE foo IS NULL;)

The = character has different meanings in these two cases.

UPDATE foos
SET foo = NULL  -- assignment
WHERE bar IS NULL -- comparison    AND foo = 'ignore me' -- comparison

Or is that what the smiley was about? :)

Michael Glaesemann
grzm seespotcode net