Postgres Pro
Downloads
Home   >   mailing lists

Re: 7.3 Prepared statements - Mailing list pgsql-general

From Francisco J Reyes
Subject Re: 7.3 Prepared statements
Date
Msg-id 20021226123329.L42523-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: 7.3 Prepared statements  (Neil Conway <neilc@samurai.com>)
Responses Re: 7.3 Prepared statements
Re: 7.3 Prepared statements
List pgsql-general
Tree view 
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?

pgsql-general by date:

Previous
From: Sergei Levchenko
Date:
Subject: MOVE ABSOLUTE num FROM my_cursor
Next
From: Simon Mitchell
Date:
Subject: Re: Trouble with UNIX TimeStamps