On Mon, Mar 08, 2021 at 06:31:56PM -0500, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> raf <raf(at)raf(dot)org> 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