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