Re:

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/