Re: [INTERFACES] manipulate array wiht ecpg

Поиск
Список
Период
Сортировка
От Michael Meskes
Тема Re: [INTERFACES] manipulate array wiht ecpg
Дата
Msg-id 19991227142330.A949@fam-meskes.de
обсуждение исходный текст
Ответ на manipulate array wiht ecpg  ("S.F. Lee" <sflee_tw@yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: Arien Vijn
Дата:
Сообщение: ...
Следующее
От: Robert Hiltibidal
Дата:
Сообщение: Re: [INTERFACES] RE: ODBC and RDO