plpgsql: PERFORM SELECT id INTO TEMP TABLE .. - Mailing list pgsql-general

From Janning Vygen
Subject plpgsql: PERFORM SELECT id INTO TEMP TABLE ..
Date
Msg-id 200207041401.g64E1vX16387@janning.planwerk6.local
Whole thread Raw
Responses Re: plpgsql: PERFORM SELECT id INTO TEMP TABLE ..
List 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



pgsql-general by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: Carraige Return issues
Next
From: Herbert Liechti
Date:
Subject: Re: query problem in 7.2.1: serious planner issue