Temp table and loop call from one session

From: Dmitriy Yusupov <dj(at)ns(dot)anapa(dot)org(dot)ru>
To: pgsql-sql(at)postgresql(dot)org
Subject: Temp table and loop call from one session
Date: 2000-06-07 14:21:48
Message-ID: 393E5A7C.7966896B@ns.anapa.org.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all!

I try to do:

PL function 1
loop:
call PL function 2

PL function 2
create temp table ...
...
drop temp table

But drop can't work in one session! It's documented.
The method with create-drop temp table is most efficient for my
problem.
What can I do? Any idea?


Dmitriy

Browse pgsql-sql by date

  From Date Subject
Next Message Niall Smart 2000-06-07 15:24:49 Problem with subquery in CHECK constraint.
Previous Message mikeo 2000-06-07 14:14:23 Re: [SQL] oracle rownum equivalent?