Any legal PostgreSQL statement(s) should work. However, I don't think
multiple resultset are allowed. The big thing is that you are avoiding the
MS Jet Engine. This will allow you access any non-standard functions and
syntax available to PostgreSQL.
If you don't know, Jet has many benifits. Like performing outer joins and
cross-tabulation.
----- Original Message -----
From: Gregg Berkholtz <gregg@gbcomputers.com>
To: Access Developer listserv <accessd@mtgroup.com>; Postgres interface list
<pgsql-interfaces@postgreSQL.org>
Sent: Saturday, January 23, 1999 3:08 PM
Subject: [INTERFACES] MS Access 97 and Pass-through SQL
>Does anyone know what pass-through SQL statements cannot be used with
>PostgreSQL connections via ODBC.
>I am running PostgreSQL 6.4.2.
>
>Thanks greatly!
>
>Gregg Berkholtz
>
>