| From: | Guyren Howe <guyren(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, raf <raf(at)raf(dot)org> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Bysani, Ram <rbysani(at)informatica(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Need help with clarification on stored procedure support in PostGreSQL database |
| Date: | 2021-03-09 04:31:53 |
| Message-ID: | af8a3c82-a207-437c-a8ed-9014cb7428f1@Spark |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)raf(dot)org>, wrote:
> 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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brent Wood | 2021-03-09 04:39:53 | Re: Need help with clarification on stored procedure support in PostGreSQL database |
| Previous Message | raf | 2021-03-09 00:53:00 | Re: Need help with clarification on stored procedure support in PostGreSQL database |