plpgsql: PERFORM SELECT id INTO TEMP TABLE ..

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

Janning Vygen wrote:
> 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.
>

I think the INTO conflicts with the INTO used in plpgsql variables. Use
CREATE TEMP TABLE AS SELECT ... in plpgsql. That should work.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026