This seems like an important consideration. I’ve spent 10 minutes searching the documentation for PG 11 and can’t find where it is documented. Perhaps it should be made more prominent?
On Mar 8, 2021, 16:53 -0800, raf <raf@xxxxxxx>, wrote:
On Mon, Mar 08, 2021 at 06:31:56PM -0500, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
raf <raf@xxxxxxx> writes:
Is there any important different between a stored procedure and
a stored function that returns void? I've been using functions
for everything but calling them procedures in my head (even though
most of them do return a value or result set).
A procedure can commit or rollback a transaction (and then start
a new one).
regards, tom lane
thanks.
cheers,
raf
