Re: comparing rows

Magnus Hagander <mha@sollentuna.net> writes:
> Summary of MS:
> When it runs in ANSI mode, null != null.
> When it runs in backwards compatible mode , null=null.

Oh, that's interesting, they fixed their bug.

foo = NULL should produce NULL (*not* true, and *not* false either,
though it'd act like false in a CASE test).

Here is one vote for ripping out our parser kluge and making null act
like it should according to the spec.  Comments?
        regards, tom lane