Handling of Arrays broken..?

Hi,

Since upgrading to PostgreSQL 9.1.2 and its psql-odbc driver (9.0.3.10),
the results of queries to arrays seems broken. I have an SQL 'items'
column of type character(3)[]. A 'normal' SQL query 'SELECT items FROM
table' results in a proper Array (shows in PgAdmin as {100,999,122} ).

In ASP JavaScript the same query done in an ADODB connection...

SQLcmd.CommandText = "SELECT items FROM table";
var RecSet = SQLcmd.Execute;

while (!RecSet.EOF && !RecSet.BOF) {
var theItemsStr = RecSet.Fields.Item("items").Value;

...results in theItemsStr being '{10'

The same code worked in an earlier installation with Postgres 8.4 and its
driver (version?).

By accident I found that the same thing with the SQL "SELECT items[1:99]
FROM table" does work correctly (even if the array only has 3 items). Is
this a bug that has been introduced in the new version of the driver, or
is there something else I missed...?

Yours,

--
Barend Köbben
ITC - University of Twente,
Faculty of Geo-Information Science and Earth Observation
PO Box 217, 7500AE Enschede (The Netherlands)
+31-(0)53 4874 253

Faculty of Geo-Information Science and Earth Observation (ITC)
University of Twente
Chamber of Commerce: 501305360000

E-mail disclaimer
The information in this e-mail, including any attachments, is intended for the addressee only. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or action in relation to the content of this information is strictly prohibited. If you have received this e-mail by mistake, please delete the message and any attachment and inform the sender by return e-mail. ITC accepts no liability for any error or omission in the message content or for damage of any kind that may arise as a result of e-mail transmission.