Horton

RE: [HACKERS] Cache query implemented

Karel Zak <zakkr@zf.jcu.cz>

View thread
From: Karel Zak - Zakkr <zakkr@zf.jcu.cz>
To: Hiroshi Inoue <Inoue@tpf.co.jp>
Cc: Peter Eisentraut <peter_e@gmx.net>, Jan Wieck <wieck@debis.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers <pgsql-hackers@postgreSQL.org>
Date: 2000-02-29T12:51:35Z
Lists: pgsql-hackers 
On Tue, 29 Feb 2000, Hiroshi Inoue wrote:

> > -----Original Message-----
> > From: Karel Zak - Zakkr [mailto:zakkr@zf.jcu.cz]
> > 
> > > > EXECUTE name [ INTO x, y, ... ] [ USING a, b, ... ]
> > > 
> > >  This command "Associate input parametrs and output targets 
> > with a prepared
> > > statement and execute the statement" (SQL92).
> > > 
> 
> I don't know well about PREPARE statement.
> But is above syntax for interative SQL command ?
> Isn't it for embedded SQL or SQL module ?

 - PREPARE save to cache any standard sql command (OptimizableStmt).
 - EXECUTE run this cached plan (query) and send data to frontend or
   INTO any relation.

 Or what you mean?

							Karel