On 7/1/20 9:32 PM, Pavel Stehule wrote: > 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?
The SQL Standard.
The SQL Standard is really big, and is very possible so I miss this part. Can you send me a link?
Regards
Pavel
> 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.