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
