BUG #2417: bug for finding string in column

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...