Message-ID: <01C0F00D.8A800260.mascarm@mascari.com>
From: Mike Mascari <mascarm@mascari.com>
Reply-To: "mascarm@mascari.com" <mascarm@mascari.com>
To: "'Tom Lane'" <tgl@sss.pgh.pa.us>
Cc: "'Tom Ivar Helbekkmo'" <tih@kpnQwest.no>, Stephan Szabo
	<sszabo@megazone23.bigpanda.com>, Mark Stosberg <mark@summersault.com>,
	"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
Organization: Mascari Development Inc.
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit


> > 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