Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards - Mailing list pgsql-sql

From Tom Lane
Subject Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards
Date
Msg-id 9679.992012666@sss.pgh.pa.us
Whole thread Raw
Responses Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
Mike Mascari <mascarm@mascari.com> writes:
> The best solution would be to have the ODBC translate instances of '= 
> NULL' into IS NULL before submitting the query to PostgreSQL.

Does Access only talk to Postgres via ODBC?  (Seems plausible, but I
don't know.)  What about people copying-and-pasting queries generated
by Access; is it even possible?

I doubt that this'd really help much, in any case; it merely moves the
necessary switch from the backend to ODBC.
        regards, tom lane


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: behavior of ' = NULL' vs. MySQL vs. Standards
Next
From: Luis Sousa
Date:
Subject: Rule ON DELETE, to perform to DELETE querys !