Christopher Kings-Lynne <chriskl@familyhealth.com.au> 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