Group: pgsql.sql


Subject: Difference between "foo is false" and "foo=false"? Partial index on boolean.
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 9/4/2007 12:56:46 AM
Bryce Nesbitt <bryce1@obviously.com> writes: > Could someone explain > the difference between "foo=false" and "foo is false", for a boolean > type column? They give different results for NULL --- specifically, NULL for the former and FALSE for the latter. Don't blame me, it's in the spec... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings