Re: PG 8.2.7, ECPG & Composite types..
Michael Meskes <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.interfaces |
|---|---|
| Message-ID | <[email protected]> |
On Wed, Apr 30, 2008 at 05:11:52PM -0700, List User wrote: > and in ECPG we have tried various things which either end up with a > mismatch between column count & value count; or generate an error > where the values for the embedded composite type have been melded > together as a text string and telling us that the resulting string > is an invalid floating point value. Following is an example of the > latter error: > > exec sql insert into items ( name, price.amt, price.iso, stock ) > values ( 'Test Item', 99.2, 1, 101 ); It says this has an invalid floating point? Could you produce a small test case so we can work on the same example? Also could you enable logging and post the logs? Michael -- Michael Meskes Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org) ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: [email protected] Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL! -- Sent via pgsql-interfaces mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-interfaces