On Thu, 2003-01-09 at 22:48, Christopher Kings-Lynne wrote:
> With prepared statements being all well and good, how do I know if the query
> has not yet been prepared in the backend? Or is this simply a situation
> where I can't win?
Try the EXECUTE; if it fails, run the PREPARE and then rerun the
EXECUTE.
It would be pretty trivial to add a function that checks if a query with
a given name has already been prepared -- is that worth doing?
Cheers,
Neil