| From: | Karel Zak - Zakkr <zakkr(at)zf(dot)jcu(dot)cz> |
|---|---|
| To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
| Cc: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Jan Wieck <wieck(at)debis(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org> |
| Subject: | RE: [HACKERS] Cache query implemented |
| Date: | 2000-02-29 12:51:35 |
| Message-ID: | Pine.LNX.3.96.1000229133620.6155A-100000@ara.zf.jcu.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 29 Feb 2000, Hiroshi Inoue wrote:
> > -----Original Message-----
> > From: Karel Zak - Zakkr [mailto:zakkr(at)zf(dot)jcu(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 2000-02-29 13:17:08 | RE: [HACKERS] Re: ALTER TABLE DROP COLUMN |
| Previous Message | Karel Zak - Zakkr | 2000-02-29 12:24:37 | Re: [HACKERS] Re: [PATCHES] NO-CREATE-TABLE and NO-LOCK-TABLE |