Re: SQL-standard function body
| От | Pavel Stehule |
|---|---|
| Тема | Re: SQL-standard function body |
| Дата | |
| Msg-id | CAFj8pRBxFYn=dnvEAox3ck1jhY+nfpogehw-mSWT49_MXj_HRA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: SQL-standard function body (Vik Fearing <vik@postgresfriends.org>) |
| Ответы |
Re: SQL-standard function body
|
| Список | pgsql-hackers |
st 1. 7. 2020 v 20:19 odesílatel Vik Fearing <vik@postgresfriends.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? Maybe we are speaking (and thinking) about different languages.
I thought the language of SQL functions (ANSI/SQL) is SQL/PSM.
Regards
Pavel
(There are a few statements that are not allowed, such as COMMIT.)
--
Vik Fearing
В списке pgsql-hackers по дате отправления: