Skip site navigation (1) Skip section navigation (2)

Best way Driver 8.04.01 with Release 9.0

From: "jsilberberg(at)mindspring(dot)com" <jsilberberg(at)mindspring(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Best way Driver 8.04.01 with Release 9.0
Date: 2010-12-12 22:58:50
Message-ID: 11446567.1292194731217.JavaMail.root@mswamui-cedar.atl.sa.earthlink.net (view raw or flat)
Thread:
Lists: 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..  

Responses

pgsql-odbc by date

Next:From: Richard BroersmaDate: 2010-12-13 15:16:36
Subject: Re: Best way Driver 8.04.01 with Release 9.0
Previous:From: Hiroshi InoueDate: 2010-12-09 10:31:44
Subject: Re: Problem with psqlodbc

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group