Best way Driver 8.04.01 with Release 9.0 - Mailing list pgsql-odbc

From jsilberberg@mindspring.com
Subject Best way Driver 8.04.01 with Release 9.0
Date
Msg-id 11446567.1292194731217.JavaMail.root@mswamui-cedar.atl.sa.earthlink.net
Whole thread Raw
Responses Re: Best way Driver 8.04.01 with Release 9.0  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-odbc
We have moved a server to PostgreSQL 9.n this past weekend with great results so far.

One small issue I have is that we are now using arrays in the DB and I can't find a way to
access them in MS Access 2007 with the OBDC Driver 8.04.01.

In PostgreSQL  the Statement is  Select * from table where 1000 = ANY(array_entry);
As documented in chapter 8.14.5

Tried this syntext in MS Access 2007 with no joy, does anyone happen to know how this
should be handled in MS Access read only Selects.

TIA,
JMS..

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Problem with psqlodbc
Next
From: Richard Broersma
Date:
Subject: Re: Best way Driver 8.04.01 with Release 9.0