On Thu, Jun 20, 2002 at 17:28:31 +0200, Ingo Ciechowski <[EMAIL PROTECTED]> wrote: > Hi, > > first of all let me tell all of you that PostgreSQL is among the best > in OpenSource! > > Unfortunaly there's a (hopefully easy to fix) bug in release 7.2 and > 7.2.1 that was not there in 7.1.3 and caused me to switch back today. > > > Here's the table I'm using (unfortunately I already switched back to > 7.1.3 and therefore can't verify whether or not this occurs with an > easier setup):
7.1 had a hack because = NULL worked that way in Microsoft's DB. You want to use 'IS NULL' to match null values. '= NULL' will always be 'unknown' (which isn't 'true' so the where clause won't be satisified). ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])