Re: Three valued logic (again)
Jason Restad <jasr@itc.nrcs.usda.gov> writes:
[ deleted some ]
>
> However, I am still am left with a puzzle related to NULLs.
> Here is a query to demonstrate:
>
> set explain on;
> CREATE TABLE tbl ( col int);>
> INSERT INTO tbl VALUES (1);
> INSERT INTO tbl VALUES ('');>
> SELECT COUNT(*) FROM tbl WHERE col IS NULL;
> SELECT COUNT(col) FROM tbl WHERE col IS NULL;
I get syntax error on this one. In isql 4.00, dbaccess 5.00, dbaccess 7.14.
--
'yvind Gjerstad Systems dept Tollpost-Globe AS N-6301 'ndalsnes/Norway
E-mail: ogj@it.tollpost.no Phone: +47 7122 6663 Fax: +47 7122 6694