Re: Proposal: real procedures again (8.4) - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: Proposal: real procedures again (8.4)
Date
Msg-id 877il820ey.fsf@oxford.xeocode.com
Whole thread Raw
In response to Proposal: real procedures again (8.4)  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Responses Re: Proposal: real procedures again (8.4)
Re: Proposal: real procedures again (8.4)
List pgsql-hackers
"Pavel Stehule" <pavel.stehule@gmail.com> writes:

> Later:
> * procedure can manages transactions,

Personally this is the only actual feature on the list that seems to have any
point to me.

> Why new calling convention? I would to support byref variables and
> then I have to carry memory context info ... and maybe some others

I think first you have to invent something for the by-ref parameter to refer
to. We don't currently have any kind of "variables" which can be mutated. We
just have immutable datums which get passed up the query. Effectively SQL is a
functional programming language in that sense.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Proposal: real procedures again (8.4)
Next
From: Gregory Stark
Date:
Subject: min/max planner optimization