Horton

Re:

Juliano Ignacio <jsignacio@yahoo.com>

View thread View on postgr.es
From: Juliano Ignacio <jsignacio@yahoo.com>
To: Bhuvan A <bhuvansql@yahoo.com>
Cc: pgsql-bugs@postgresql.org
Date: 2002-03-11T20:12:07Z
Lists: pgsql-bugs 
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/