Michael Meskes <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]