Re: SQL-standard function body

st 1. 7. 2020 v 22:31 odesílatel Vik Fearing <vik(at)postgresfriends(dot)org>
napsal:

> 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.
>

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.
>
--
> Vik Fearing
>