Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> I tried replacing it with:
> UPDATE food_foods SET included=(verification_status = 'I');
> However, that set included to true only where verification_status=I, it
> didn't set false at all.
You'd have gotten NULL, not FALSE, at the rows where verification_status
is NULL.
You could try coalesce, or "(verification_status = 'I') IS TRUE", to
get something that returns false instead of null.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
