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
PGP.sig
Description: This is a digitally signed message part
