On Sun, Dec 12, 2010 at 2:58 PM, jsilberberg@mindspring.com
<jsilberberg@mindspring.com> wrote:
> 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.
Unfortunately, the ODBC driver for 9.0 wasn't ready at the time of
release. You can get the 9.0 version here:
http://www.postgresql.org/ftp/odbc/versions/msi/
However, since array syntax was a PRE-9.0 feature, it would matter if
you upgraded to the 9.0 driver.
> 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.
MS-Access should support this query using either a pass-through query
or an ADODB result-set. Ordinary queries or DAO results set will not
work.
Also, how are you passing the "array_entry?" If you are actually
passing an array to a pass-through query, it might not work. I
haven't tried it so I don't know, but I would expect it to. If your
using pass-through queries, it would be better to pass a comma
delimited string to a query like:
Select * from table where 1000 = ANY( string_to_array( "1,2,3,4,5,6","," ));
Although, it seems that and ADODB command can have arrary parameters.
Which could return a result set directly from an array. Notice:
http://msdn.microsoft.com/en-us/library/ms675318%28v=vs.85%29.aspx
Does that help?
--
Regards,
Richard Broersma Jr.