Re: comparing rows - Mailing list pgsql-hackers

From Tom Lane
Subject Re: comparing rows
Date
Msg-id 7818.965313624@sss.pgh.pa.us
Whole thread Raw
In response to Re: comparing rows  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: comparing rows
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> I thought our only kludge was allowing = NULL because we got tons of MS
> folks complaining in the past before we did this.  Are you thinking that
> the newer MS versions will not give us a problem.

Well, I'm not sure.  Magnus is saying that the newer MS servers default
to spec-compliant semantics --- ie, foo = NULL will yield NULL.  But
IIRC the original complaints were because MS tools like Access would
*generate* this expression and expect it to behave like foo IS NULL.

Can MS have fixed all their apps already?  Seems unlikely.  Maybe we
have to leave the kluge in there awhile longer.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: comparing rows
Next
From: Don Baccus
Date:
Subject: Re: comparing rows