Re: 7.3 Prepared statements

From: Alan Gutierrez <ajglist(at)izzy(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.3 Prepared statements
Date: 2003-01-06 10:35:50
Message-ID: avbmb4$1m6b$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Francisco J Reyes wrote:
> On 17 Dec 2002, Neil Conway wrote:
>
>
>>On Tue, 2002-12-17 at 10:19, Ericson Smith wrote:
>>
>>>1. What is the lifetime of the plan created?
>>
>>>From the PREPARE reference page:
>>
>>Prepared queries are stored locally (in the current backend), and only
>>exist for the duration of the current database session.
>
>
> What is the difference/advantage between a prepared query and a view?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

The idocs are still at 7.2.1. Is there an API for the prepared query interface
in a later version of libpq? In libpq-fe.h there doesn't seem to be a statement
structure or prepare call. Examples of prepared query use?

Alan Gutierrez

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Prachi Jain 2003-01-06 11:57:58 result set supported
Previous Message Alan Gutierrez 2003-01-06 10:20:25 How to Implement Versioned Rows in PostgreSQL?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jim Downing 2003-01-06 15:25:48 [jp@mobicomp.com: Re: Idle in Transaction] -- SOLUTION
Previous Message Dave Cramer 2003-01-06 03:03:38 Re: Idle in Transaction