Re: SQL-standard function body - Mailing list pgsql-hackers

From Vik Fearing
Subject Re: SQL-standard function body
Date
Msg-id ad9572f7-45d7-0095-3fa7-93cb4d70114b@postgresfriends.org
Whole thread Raw
In response to Re: SQL-standard function body  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: SQL-standard function body
List pgsql-hackers
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.

(There are a few statements that are not allowed, such as COMMIT.)
-- 
Vik Fearing



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: proposal - plpgsql - FOR over unbound cursor
Next
From: Andres Freund
Date:
Subject: Re: POC: postgres_fdw insert batching