Re: [INTERFACES] manipulate array wiht ecpg - Mailing list pgsql-interfaces

From Michael Meskes
Subject Re: [INTERFACES] manipulate array wiht ecpg
Date
Msg-id 19991227142330.A949@fam-meskes.de
Whole thread Raw
In response to manipulate array wiht ecpg  ("S.F. Lee" <sflee_tw@yahoo.com>)
List pgsql-interfaces
On Mon, Dec 27, 1999 at 01:51:39AM -0800, S.F. Lee wrote:
>    I am using ecpg to manipulate the whole row in a
> table,and I have a problem in array, can anybody give
> me a hint or a small test program to process array?

Unfortunately this is a known bug in ecpg. It's listed on the TODO list.
However, I have no idea so far how to fix it. The only way you can insert an
array is by listing its members. That is you have to create your insert
statement via sprintf for instance and use exec sql execute immediate.

Sorry. I will fix it as soon as I find a solution.

The problem is that ecpg also allows inserting the whole array as single
integers by only listing the array.

Michael
-- 
Michael Meskes                         | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz    | Go Rhein Fire!
Tel.: (+49) 2431/72651                 | Use Debian GNU/Linux!
Email: Michael@Fam-Meskes.De           | Use PostgreSQL!


pgsql-interfaces by date:

Previous
From: Arien Vijn
Date:
Subject: ...
Next
From: Robert Hiltibidal
Date:
Subject: Re: [INTERFACES] RE: ODBC and RDO