On Mon, 11 Mar 2002, Bhuvan A wrote:
> If you compare a NULL with anything you don't
> get a true value whether you're comparing with
> =, !=, <, >, etc... That's how it's defined to
> behave.
>
> where did you get this definition of behaviour!?
> is it applicable only to
> postgres or ..? its quite strange yaar!
I think that you are searching for a solution, so,
view the COALESCE SQL function in PostgreSQL
documentation. It will help you in your compares.
Juliano S. Ignacio
jsignacio@yahoo.com
__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/