Re: [HACKERS] PREPARE - Mailing list pgsql-hackers

From Michael Meskes
Subject Re: [HACKERS] PREPARE
Date
Msg-id 19981117203009.E1442@usa.net
Whole thread Raw
In response to Re: [HACKERS] PREPARE  ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>)
List pgsql-hackers
On Tue, Nov 17, 1998 at 01:45:19PM +0000, Thomas G. Lockhart wrote:
> So what would it take to do this in the backend? I think the places
> which would need to be touched fall into areas I either know about or am
> starting to look at to implement the CASE clause.
> 
> We'd need:
>   - a "named buffer" (or several) to hold the intermediate input

I didn't get this one completly. What input do you mean?

>   - a way to pass in parameters or substitution arguments

Yes. That means changing of declare cursor as well.

>   - a way to decide if previous parser/planner/executor
>     results can be reused

Yes.

> What else?

Running planner on the statement as it is without the variables to be
substituted. So execution of declare gets faster.

Michael
-- 
Dr. Michael Meskes, Manager of the Western Branch Office, Datenrevision GmbH
work: Cuxhavener Str. 36, D-21149 Hamburg
home: Th.-Heuss-Str. 61,  D-41812 Erkelenz, Michael.Meskes@usa.net
Go SF49ers! Go Rhein Fire! Use Debian GNU/Linux!




pgsql-hackers by date:

Previous
From: Terry Mackintosh
Date:
Subject: SPI function help needed.
Next
From: Michael Meskes
Date:
Subject: Re: [HACKERS] More PostgreSQL+CORBA