Temp table and loop call from one session - Mailing list pgsql-sql

From Dmitriy Yusupov
Subject Temp table and loop call from one session
Date
Msg-id 393E5A7C.7966896B@ns.anapa.org.ru
Whole thread Raw
List 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


pgsql-sql by date:

Previous
From: Niall Smart
Date:
Subject: Problem with subquery in CHECK constraint.
Next
From: Ed Loehr
Date:
Subject: Re: oracle rownum equivalent?