Thread: plpgsql problems

plpgsql problems

From
Pawel Pierscionek
Date:
Hi,

 I  love  plpgsql  but  don't  know how to do the following in plpgsql:
 1) DROP TABLE mydata
    (I get backend crash no matter if it exists on not)
 2) SELECT id INTO TABLE tmp FROM mydata
    (I get 'query "SELECT id into table tmp from mydata" isn't a SELECT')

any clue ? (I've tried 6.4.0 & 6.4.2)

TIA,
Pawel Pierscionek