plpgsql problems

From: Pawel Pierscionek <pawel(at)astercity(dot)net>
To: pgsql-sql <pgsql-sql(at)postgreSQL(dot)org>
Subject: plpgsql problems
Date: 1999-01-06 09:50:09
Message-ID: 13451.990106@astercity.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 1999-01-06 10:19:38 Re: [SQL] drop table in pgsql
Previous Message martin 1999-01-06 07:01:35 placeholders