From: Mike Mascari <mascarm@mascari.com>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: 'Tom Ivar Helbekkmo' <tih@kpnQwest.no>
Cc: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: Mark Stosberg <mark@summersault.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: RE: Re: [SQL] behavior of ' = NULL' vs. MySQL vs. Standards
Date: Fri, 8 Jun 2001 11:24:10 -0400
Message-ID: <01C0F00D.8A800260.mascarm@mascari.com> (raw)
> > The best solution would be to have the ODBC translate instances
of '=
> > NULL' into IS NULL before submitting the query to PostgreSQL.
Tom Lane wrote:
> 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?
1. Yes, Access only talkes to Postgres via ODBC.
2. The queries generate by Access which use the '= NULL' vs. 'IS
NULL' language are only generated through the use of Access Forms,
when some attempts to fetch a record through the forms interface
where the key of the linked table is an empty edit control. When
access generates queries, it correctly generates 'IS NULL' language.
It is a *very specific problem* WRT the user of Access Forms.
> I doubt that this'd really help much, in any case; it merely moves
the
> necessary switch from the backend to ODBC.
It seems to me that is where it belongs. The ODBC driver is already
doing translation of some Access functions not found in PostgreSQL
such as LCASE->lower, etc. The kludge isn't found in any other RDBMS
of which I am aware (certainly not Oracle), and yet Access works fine
with them,
Just MHO of course,
Mike Mascari
mascarm@mascari.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: mascarm@mascari.com, tgl@sss.pgh.pa.us, tih@kpnQwest.no, sszabo@megazone23.bigpanda.com, mark@summersault.com
Subject: RE: Re: [SQL] behavior of ' = NULL' vs. MySQL vs. Standards
In-Reply-To: <01C0F00D.8A800260.mascarm@mascari.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox