Re: [HACKERS] Prepared statements question

2003-01-12 Thread Christopher Kings-Lynne
OK, how about a backend function called 'is_prepared(name)'? Chris > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Kevin Brown > Sent: Monday, 13 January 2003 11:13 AM > To: PostgreSQL Hackers > Subject: Re: [HACKERS]

Re: [HACKERS] Prepared statements question

2003-01-12 Thread Kevin Brown
Neil Conway wrote: > 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, ru

Re: [HACKERS] Prepared statements question

2003-01-09 Thread Neil Conway
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 th

Re: [HACKERS] Prepared statements question

2003-01-09 Thread Christopher Kings-Lynne
I guess I should just use a stored procedure... Chris > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Christopher > Kings-Lynne > Sent: Friday, 10 January 2003 11:48 AM > To: Hackers > Subject: [HACKERS] Prepared statement

[HACKERS] Prepared statements question

2003-01-09 Thread Christopher Kings-Lynne
Hi, 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? eg. Say I have a web page that does a humungous query. I would like to have that query prepared, say, for speed. However,