Re: storing intermediate results in recursive plpgsql functions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fran Fabrizio <ffabrizio(at)mmrd(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: storing intermediate results in recursive plpgsql functions
Date: 2002-03-01 22:24:21
Message-ID: 2514.1015021461@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Fran Fabrizio <ffabrizio(at)mmrd(dot)com> writes:
> I feel like I'm missing something obvious.

Well, you could use a temp table if you access it via EXECUTEd commands.
Or you could use a non-temp table and just not unlock; let the unlock
happen at normal end of transaction. The latter is probably easier.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Randy Widell 2002-03-01 22:52:00 Running under Cygwin...
Previous Message Francisco Reyes 2002-03-01 22:23:12 Re: Shared buffers vs large files