ecpg failed and Postmaster getting bigger

>>
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/