plpgsql: PERFORM SELECT id INTO TEMP TABLE ..

From: Janning Vygen <vygen(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: plpgsql: PERFORM SELECT id INTO TEMP TABLE ..
Date: 2002-07-04 14:01:56
Message-ID: 200207041401.g64E1vX16387@janning.planwerk6.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

i am trying to create a temorary table inside a plpgsql function.

i tried something like this:
PERFORM SELECT name into temp table Names FROM person;

is it just not possible to create a temporary table inside plpgsql ??
Or did i just made a syntax error and have to keep my eyes open??

before trying and trying for hours, it would be a great help to know
if its possible. Its not documented, but docs say that you can
perform any query within a perform statement.

(postgresql version 7.2.1)

kind regards,
janning

p.s: debugging plpgsql functions is no fun at all :-(

--
Planwerk 6 /websolutions
Herzogstraße 86
40215 Düsseldorf

fon 0211-6015919
fax 0211-6015917
http://www.planwerk6.de

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2002-07-04 14:05:34 Re: EVAL and SET equivalents in PostgreSQL
Previous Message Thomas Lockhart 2002-07-04 13:57:52 Re: epoch from date field