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 [EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
