From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: "stored procedures" |
Date: | 2011-05-09 18:41:29 |
Message-ID: | 201105091841.p49IfTb24085@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Josh Berkus wrote:
> Peter,
>
> > I would like to collect some specs on this feature. So does anyone have
> > links to documentation of existing implementations, or their own spec
> > writeup? A lot of people appear to have a very clear idea of this
> > concept in their own head, so let's start collecting those.
>
> Delta between SPs and Functions for PostgreSQL:
>
> * SPs are executed using CALL or EXECUTE, and not SELECT.
>
> * SPs do not return a value
> ** optional: SPs *may* have OUT parameters.
[ Late reply.]
What is it about stored procedures that would require it not to return a
value or use CALL? I am trying to understand what part of this is
"procedures" (doesn't return a values, we decided there isn't much value
for that syntax vs. functions), and anonymous transactions.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2011-05-09 18:41:41 | Re: Formatting Curmudgeons WAS: MMAP Buffers |
Previous Message | Robert Haas | 2011-05-09 18:31:33 | Re: Why not install pgstattuple by default? |