| From: | Francisco J Reyes <fran(at)natserv(dot)net> |
|---|---|
| To: | Neil Conway <neilc(at)samurai(dot)com> |
| Cc: | Ericson Smith <eric(at)did-it(dot)com>, Postgresql General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 7.3 Prepared statements |
| Date: | 2002-12-26 17:34:04 |
| Message-ID: | 20021226123329.L42523-100000@zoraida.natserv.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-jdbc |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Lester | 2002-12-26 18:28:31 | Moving from 4D to Postgres |
| Previous Message | Sergei Levchenko | 2002-12-26 17:03:17 | MOVE ABSOLUTE num FROM my_cursor |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Barry Lind | 2002-12-26 17:41:59 | Re: OT jdbc2.0 extention |
| Previous Message | Felipe Schnack | 2002-12-26 17:12:46 | Re: statement's hashCode() |