Michael Meskes <meskes@postgresql.org> writes:
> On Thu, Sep 12, 2002 at 09:07:20AM -0400, Tom Lane wrote:
>> But you must implement your own PREPARE/EXECUTE anyway, using ecpg
>> variables, no?
> In ecpg you can use a string variable or constant holding the statement
> to prepare that statement as in
> exec sql prepare STMT from string;
Sure --- and that is exactly *not* what the backend facility does. In
the backend PREPARE you supply the statement to be prepared directly in
the same SQL command, not as the value of some variable.
> Now if you have a parameter in the prepared statement by just specify
> "?" instead some value, you add a using clause during execution to set
> the values.
And a plain "?" isn't going to fly as the parameter marker, either.
The backend wants to know what datatype each parameter is supposed to
be.
regards, tom lane