From: | Vik Fearing <vik(at)postgresfriends(dot)org> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: SQL-standard function body |
Date: | 2020-07-01 20:31:26 |
Message-ID: | 61fa89a9-c39f-f780-1bf0-9ff4d387a9da@postgresfriends.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 7/1/20 9:32 PM, Pavel Stehule wrote:
> st 1. 7. 2020 v 20:19 odesílatel Vik Fearing <vik(at)postgresfriends(dot)org>
> napsal:
>
>> On 7/1/20 3:36 PM, Robert Haas wrote:
>>> I actually don't have a very clear idea of what the standard has to
>>> say about SQL-language functions. Does it just say it's a list of
>>> statements, or does it involve variables and control-flow constructs
>>> and stuff like that, too?
>>
>>
>> It's either a single sql statement, or a collection of them between
>> "begin atomic" and "end". There are no variables or flow control
>> constructs or anything like that, just as there are no such things
>> outside of a function.
>>
>
> What is the source of this comment?
The SQL Standard.
> Maybe we are speaking (and thinking)
> about different languages.
I think so, yes.
> I thought the language of SQL functions (ANSI/SQL) is SQL/PSM.
That is something else entirely, and not at all what Peter's patch is about.
--
Vik Fearing
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2020-07-01 20:32:46 | Re: POC: rational number type (fractions) |
Previous Message | Bruce Momjian | 2020-07-01 20:29:37 | Re: Remove Deprecated Exclusive Backup Mode |