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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])