execute immediate - Mailing list pgsql-interfaces

From Michael Meskes
Subject execute immediate
Date
Msg-id 20070613125241.GA27209@feivel.credativ.de
Whole thread Raw
List pgsql-interfaces
According to the standard EXEC SQL EXECUTE IMMEDIATE dynamically
prepares and executes a statement. ECPG used to just simulate this by
simply executing the statement. But before rewriting this I wonder if it
makes any sense at all. Where's the advantage of preparing a statement,
then executing it and then of course deallocating it again over a simple
execution?

The EXEC SQL EXECUTE IMMEDIATE clause is needed to be able to
dynamically compute the statement to be executed, but do we really need
to prepare it?

Michael
-- 
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
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: Michael Meskes
Date:
Subject: Re: PQprepare case sensitive?
Next
From: René Grün
Date:
Subject: NAN-Values in ECPG-Code