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

Re: Handling of Arrays broken..?

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: (view raw, whole thread or download thread mbox)
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 (,
> 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

Inoue, Hiroshi

In response to


pgsql-odbc by date

Next:From: Barend KöbbenDate: 2012-03-30 13:17:55
Subject: Re: Handling of Arrays broken..?
Previous:From: noreplyDate: 2012-03-28 03:28:24
Subject: [ psqlodbc-Bugs-1010500 ] UUID not being returned correctly

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