Re: pg_get_prepared? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: pg_get_prepared?
Date
Msg-id 42D76062.3040504@familyhealth.com.au
Whole thread Raw
In response to Re: pg_get_prepared?  (Volkan YAZICI <volkan.yazici@gmail.com>)
Responses Re: pg_get_prepared?  (Volkan YAZICI <volkan.yazici@gmail.com>)
Re: pg_get_prepared?  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-hackers

Volkan YAZICI wrote:
> Hi,
> 
> On 7/15/05, Christopher Kings-Lynne <chriskl@familyhealth.com.au> wrote:
> 
>>Would it be useful to have a pg_get_prepared(name) function that returns
>>true or false depending on whether or not there is a prepared query of
>>that name?
> 
> 
> (You're mentioning about PHP PostgreSQL API, right?) I couldn't see
> any proper usage area for this. Can you give some examples?

No, I'm talking about a PostgreSQL backend function.

The use case is when you want to prepare a query, but only if it's not 
already prepared on that connection.

> Furthermore, I wondered the steps you'll follow to achieve this. How
> will you check if a prepared stmt exists or not?

Same way that the EXECUTE command checks...

Chris



pgsql-hackers by date:

Previous
From: Volkan YAZICI
Date:
Subject: Re: pg_get_prepared?
Next
From: Hannu Krosing
Date:
Subject: Re: [Bizgres-general] A Guide to Constraint Exclusion