Received: from astercity.net (astercity.net [195.116.8.78]) by hub.org (8.9.1/8.9.1) with ESMTP id EAA23774 for ; Wed, 6 Jan 1999 04:47:33 -0500 (EST) (envelope-from pawel@astercity.net) Received: from mail.astercity.net (verona58.waw.pdi.net [195.116.8.58]) by astercity.net (8.8.7/8.8.7) with SMTP id KAA01834 for ; Wed, 6 Jan 1999 10:45:17 +0100 Date: Wed, 6 Jan 1999 10:50:09 +0100 From: Pawel Pierscionek X-Mailer: The Bat! (v1.19) S/N 359CE73E Reply-To: Pawel Pierscionek Organization: PDi- Publiczny Dostep do Internetu X-Priority: 3 (Normal) Message-ID: <13451.990106@astercity.net> To: pgsql-sql Subject: plpgsql problems Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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