On Fri, Apr 28, 2000 at 05:05:10PM -0700, Matthew Denny wrote:
> Is it possible to create a DELETE statement of the form:
> EXEC SQL DELETE FROM :foo;
> Where foo holds a table name; I have tried declaring foo as both a
> VARCHAR and a regular C string (char*, NULL-term.) but both seem to
> generate a parse error. Is my only option to use dynamic SQL
> statements (e.g with the PREPARE and EXECUTE commands)?
Yes, that's how it is supposed to work.
Michael Meskes | Go SF 49ers!
Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire!
Tel.: (+49) 2431/72651 | Use Debian GNU/Linux!
Email: Michael(at)Fam-Meskes(dot)De | Use PostgreSQL!
pgsql-interfaces by date
|Next:||From: Craig Orsinger||Date: 2000-05-02 18:43:08|
|Subject: Re: ODBC and VB5 I GIVE UP!!|
|Previous:||From: Bruce Momjian||Date: 2000-05-02 17:37:43|
|Subject: Re: [HACKERS] Request for 7.0 JDBC status|