darcy@druid.net (D'Arcy J.M. Cain) writes:
> you do realize that this wouldn't work anyway, right? The following
> is a parse error.
> SELECT count(*) FROM t1 WHERE b = null;
> Mind you, I think that's a weakness but I don't know what the issues
> are with respect to the code or the standard.
I believe the accepted spelling of that query is
SELECT count(*) FROM t1 WHERE b IS NULL;
(or IS NOT NULL). I don't know either what the SQL standard has to say
about the issue --- does it expect "= NULL" to be a synonym for "IS NULL"?
The CREATE FUNCTION example does seem to illustrate that it'd be nice
if "=" and "!=" worked on NULL values. I'd still object to trying
to define an order that includes NULL, so "3 < NULL" should return NULL,
but I can see the reasonableness of defining "3 != NULL" as TRUE.
regards, tom lane