plpgsql problems - Mailing list pgsql-sql

From Pawel Pierscionek
Subject plpgsql problems
Date
Msg-id 13451.990106@astercity.net
Whole thread Raw
List pgsql-sql
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



pgsql-sql by date:

Previous
From: martin@axe.net.au
Date:
Subject: placeholders
Next
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [SQL] drop table in pgsql