From: S.F. Lee <sflee_tw@yahoo.com>
To: pgsql-interfaces@postgreSQL.org
Subject: ecpg failed and Postmaster getting bigger
Date: Thu, 18 May 2000 00:58:23 -0700 (PDT)
Message-ID: <20000518075823.1289.qmail@web217.mail.yahoo.com> (raw)
>>
values(1,10,11.1,`{1,2,3,4}`,`{"1.1","2.2","3.3"}`,0);
>Is c1 int[3] or int[4]?
sorry,
values(1,10,11.1,`{1,2,3}`,`{"1.1","2.2","3.3"}`,0);
>> 2.Modify Test.pgc to get a whole row from foo_2
into
>> a structure temp by "select *":
>> printf (" c1 = %s d1 = %s
>> ",temp.a1,temp.b1,temp.c1,temp.d1);
>This one dumps core on me since a1 and b1 are not
mentioned in the format
>string. But I guess this is not your problem. :-)
sorry, that's all my fault. :-(
printf (" c1 = %s d1 = %s
",temp.c1,temp.d1);
In PostgreSQL 6.5.3, I can't use
struct data
{
int recno;
int a1;
float b1;
int c1[3];
float d1[3];
int spare;
} temp;
as a host variable, but I find
struct data
{
int recno;
int a1;
float b1;
char c1[50];
char d1[50];
int spare;
} temp;
can apply for getting a whole row into
structure temp by "select * ". One of
the most important reason that I would
use PostgreSQL is array, that could make
me easier in building up table. And the
reason why I would like to use "select *"
is to reduce the complication in programming.
since I can use some utility to build up a
correct structure according to foo_2.sql, then
all I want is dealing with the structure.
Sorry for my poor English.
Regards, S.F. Lee
__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger.
http://im.yahoo.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: sflee_tw@yahoo.com
Subject: Re: ecpg failed and Postmaster getting bigger
In-Reply-To: <20000518075823.1289.qmail@web217.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox