plpgsql: PERFORM SELECT id INTO TEMP TABLE ..

Started by Janning Vygenalmost 24 years ago2 messagesgeneral

Jump to latest

Janning Vygen

vygen@gmx.de

almost 24 years ago

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

Bruce Momjian

bruce@momjian.us

almost 24 years ago

In reply to: Janning Vygen (#1)

Re: plpgsql: PERFORM SELECT id INTO TEMP TABLE ..

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