Re: [INTERFACES] my problems with ecpg and arrays

From: "Coleman, Andrew" <colemana(at)navo(dot)navy(dot)mil>
To: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] my problems with ecpg and arrays
Date: 1999-11-15 14:27:36
Message-ID: 78166D547FD9D2119FA700805F9FA971C0E9A2@navont3.navo.navy.mil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces


Thanks for looking into it. For the code I'm working on, it's no problem to
work around (messy, but
no problem).

>I'm afraid you find a real problem here. I just didn't think about
inserting
>arrays. If you give ecpg an array of int it inserts every single value as
>one int. That means:
>
>insert into foo(bar) values(:intarray)
>
>is equal to:
>
>for (i=0;i<maxarray;i++)
> insert into foo(bar) values(:intarray[i])
>How shall ecpg see that this time it is meant to insert the whole array?
>
>Anyone with an idea?

I'm guessing you're mostly directing that at people who are atleast vaguely
familiar with the
way pg and ecpg works internally ;)

>
>Michael

Thanks again (both for looking into it and for ecpg itself),
andrew.

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Tim Joyce 1999-11-15 14:29:42 Re: [INTERFACES] ResultSet.getDate
Previous Message ho han keng 1999-11-15 13:25:06 Re: jdbc 2.0 compilance (DatabaseMetaData)?