Re: Handling of Arrays broken..?

From: Barend Köbben <kobben(at)itc(dot)nl>
To: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Handling of Arrays broken..?
Date: 2012-03-30 13:17:55
Message-ID: CB9B7D72.518F%kobben@itc.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi mr Hiroshi,

Assuming that I correctly did the install:
- unzipped the 3 .dll files in the ZIP on that URL
- replaced the ones with the same name in C:\Program
Files\PostgreSQL\psqlODBC\0900\bin
- restarted PG

I am sorry to say that it did not help. From the SQL
"SELECT items FROM table"

I still get back the String
'{10'

And from the SQL
"SELECT items[1:99] FROM table"

the String
'{101,112,999}'

Yours,
Barend

On 30-03-12 14:55, "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp> wrote:

>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
>
>
>--
>Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-odbc

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.

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2012-03-31 09:15:55 Re: Handling of Arrays broken..?
Previous Message Hiroshi Inoue 2012-03-30 12:55:20 Re: Handling of Arrays broken..?