Weirdness with =?

Christopher Kings-Lynne <chriskl@familyhealth.com.au>

From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Hackers <pgsql-hackers@postgresql.org>
Date: 2006-01-30T08:44:21Z
Lists: pgsql-hackers
I had this code in a script:

UPDATE food_foods SET included=true WHERE verification_status = 'I';
UPDATE food_foods SET included=false WHERE verification_status IS NULL;

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.

Why doesn't this work?

Chris