RE: [HACKERS] Cache query implemented - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject RE: [HACKERS] Cache query implemented
Date
Msg-id 000501bf831e$5ea9b120$2801007e@tpf.co.jp
Whole thread Raw
In response to RE: [HACKERS] Cache query implemented  (Karel Zak - Zakkr <zakkr@zf.jcu.cz>)
Responses RE: [HACKERS] Cache query implemented
List pgsql-hackers
> -----Original Message-----
> From: Karel Zak - Zakkr [mailto:zakkr@zf.jcu.cz]
> 
> 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?
>

In old Oracle(I don't know recent Oracle,sorry),PREPARE couldn't be called
as an interactive SQL command. It was used only in embedded SQL.

Seems x, y  after INTO are output variables. In embedded SQL they are
host variables. But I don't know what they are in interactive SQL.

Regards.

Hiroshi Inoue
Inoue@tpf.co.jp


pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: minor bug in 7.0: casting
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: [HACKERS] Bug report for 7.0beta1 in 'CREATE FUNCTION...'