Обсуждение: 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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026