From: | Michael Meskes <meskes(at)usa(dot)net> |
---|---|
To: | pgsql-hackers(at)hub(dot)org |
Subject: | Re: [HACKERS] PREPARE |
Date: | 1998-11-17 19:30:09 |
Message-ID: | 19981117203009.E1442@usa.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-interfaces |
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(dot)Meskes(at)usa(dot)net
Go SF49ers! Go Rhein Fire! Use Debian GNU/Linux!
From | Date | Subject | |
---|---|---|---|
Next Message | Terry Mackintosh | 1998-11-17 20:21:11 | Re: [HACKERS] Tree type, how best to impliment? |
Previous Message | Michael Meskes | 1998-11-17 19:25:35 | Re: [HACKERS] More PostgreSQL+CORBA |
From | Date | Subject | |
---|---|---|---|
Next Message | Charles-Edouard Ruault | 1998-11-17 19:33:10 | [JDBC Problem] unable to get primary keys through DatabaseMetaData.getPrimaryKeys() |
Previous Message | Michael Meskes | 1998-11-17 19:25:35 | Re: [HACKERS] More PostgreSQL+CORBA |