Re: ECPG insert into table name as a variable - Mailing list pgsql-interfaces

From Michael Meskes
Subject Re: ECPG insert into table name as a variable
Date
Msg-id 20030924072542.GA633@feivel.fam-meskes.de
Whole thread Raw
In response to ECPG insert into table name as a variable  (Ryan Mooney <ryan@pcslink.com>)
List pgsql-interfaces
On Tue, Sep 23, 2003 at 11:12:07AM -1000, Ryan Mooney wrote:
>   EXEC SQL INSERT INTO :tname (host, point, type, cooked) VALUES (:host, :name, :type, :cooked);

This is not possible as of now, but of course could be implemented.

> When I tried hacking the resulting C code (as a test exercise) like:
> 
>   { ECPGdo(__LINE__, 0, 1, NULL, "insert into ? ( host  , point  , type  , cooked ) values (  ? ,  ? ,  ? ,  ? )",
>   ECPGt_char,&(tname),(long)0,(long)1,1*sizeof(char),

You need to specify the indicator here as this:

ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L,

>   ECPGt_char,&(host),(long)0,(long)1,1*sizeof(char),
>   ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L,
>   ECPGt_char,&(name),(long)0,(long)1,1*sizeof(char),
>   ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L,
>   ECPGt_char,&(type),(long)1,(long)1,1*sizeof(char),
>   ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L,
>   ECPGt_char,&(cooked),(long)1,(long)1,1*sizeof(char),
>   ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L,
>   ECPGt_char,(starttime),(long)30,(long)1,30*sizeof(char),
>   ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L,
>   ECPGt_char,(interval),(long)30,(long)1,30*sizeof(char),
>   ECPGt_NO_INDICATOR, NULL , 0L, 0L, 0L,
> 
> it got all funny and didn't work very well (well ok it didn't work at all):
>   pg.pgc:129 SQL Insert failed: Invalid statement name (null) in line 124.
> 
> So, I was wondering am I just missing some obvious way to do this, or
> is this not supported at all?

So far it is not, sorry.

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go SF 49ers! Go Rhein Fire! Use Debian GNU/Linux! Use PostgreSQL!


pgsql-interfaces by date:

Previous
From: Roman Bogorodskiy
Date:
Subject: Re: troubles with getting data from tables
Next
From: Lee Kindness
Date:
Subject: ECPG insert into table name as a variable