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