The following bug has been logged online:
Bug reference: 2417
Logged by: James
Email address: james@mercstudio.com
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.
example:
select * from user_profile where acc_lock <> 'Y'
where the acc_lock field for all rows were empty...
2nd, hopefully that postgresql can be flexible to accept empty '' as null
search as well...