From: | Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Barend Köbben <kobben(at)itc(dot)nl> |
Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Handling of Arrays broken..? |
Date: | 2012-03-30 12:55:20 |
Message-ID: | 4F75AD38.2080601@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Barend,
(2012/03/27 17:30), Barend Köbben wrote:
> 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...?
Could you please try the drivers on testing for 9.1.0101 at
http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/
?
regards,
Inoue, Hiroshi
From | Date | Subject | |
---|---|---|---|
Next Message | Barend Köbben | 2012-03-30 13:17:55 | Re: Handling of Arrays broken..? |
Previous Message | noreply | 2012-03-28 03:28:24 | [ psqlodbc-Bugs-1010500 ] UUID not being returned correctly |