Postgres Pro
Downloads
Home   >   mailing lists

Re: storing intermediate results in recursive plpgsql functions - Mailing list pgsql-general

From Tom Lane
Subject Re: storing intermediate results in recursive plpgsql functions
Date
Msg-id 9078.1015283143@sss.pgh.pa.us
Whole thread Raw
In response to Re: storing intermediate results in recursive plpgsql functions  (Fran Fabrizio <ffabrizio@mmrd.com>)
List pgsql-general
Tree view 
Fran Fabrizio <ffabrizio@mmrd.com> writes:
> (apprently sql functions do not automatically end
> transactions/release locks like plpgsql functions do)

Say what?  There's no difference on that score for any kind of function;
none of them end transactions or release locks at exit.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [INTERFACES] PL/pgSQL Syntax Problem
Next
From: Tom Lane
Date:
Subject: Re: lo_open problems