Hello! On Mon, 11 Mar 2002, Bhuvan A wrote:
[skip] > > 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! it's standard SQL: true and true gives true true and false gives false null and true gives null null and false gives null RTFM! Quick check on MySQL and MSSQL gives the same results. AFAIK Interbase and Oracle behaves similarly. So theory is confirmed by practice. It is very amazing to listen about contrary thing, could you please tell where you saw this? -- WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group. Phone: +7 (3832) 106228, ext.140, E-mail: [EMAIL PROTECTED] Unix is like a wigwam -- no Gates, no Windows, and an Apache inside. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
