Skip site navigation (1) Skip section navigation (2)

Re: Change the table in a DELETE statement in ECPG

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Matthew Denny <mdenny(at)cs(dot)berkeley(dot)edu>
Cc: pgsql-interfaces(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: Change the table in a DELETE statement in ECPG
Date: 2000-05-02 18:05:37
Message-ID: 20000502200537.A602@fam-meskes.de (view raw or flat)
Thread:
Lists: pgsql-interfaces
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;

No.

> 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

Yes. 

> statements (e.g with the PREPARE and EXECUTE commands)?

Yes, that's how it is supposed to work.

Michael
-- 
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 OrsingerDate: 2000-05-02 18:43:08
Subject: Re: ODBC and VB5 I GIVE UP!!
Previous:From: Bruce MomjianDate: 2000-05-02 17:37:43
Subject: Re: [HACKERS] Request for 7.0 JDBC status

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group