Re: Re: [SQL] behavior of ' = NULL' vs. MySQL vs. Standards

Tom,

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

Yes, but MS Access uses some much non-standard SQL that "= Null" would
hardly be the only problem (try to build an UPDATE ... FROM in Access)

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

Yes, but it does avoid cluttering up the PgSQL source with switches that
are only useful to a handful of users.

-Josh


______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco