On Tue, 2 May 2006, James wrote: > > The following bug has been logged online: > > Bug reference: 2417 > Logged by: James > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 > Operating system: Microsoft Windows XP Professional > Description: bug for finding string in column > Details: > > hi, > > i've encounter bug where when a field is empty / null (type varchar(255) ), > when i use the sql query <> 'myvalue', it seems to be false all the time.
If it's null, it's actually returning unknown (not true or false) and as far as we know that's not a bug because that's how SQL defines the comparison operators. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
