Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 598BD476CEA for ; Mon, 8 Jul 2002 15:32:41 -0400 (EDT) Mailbox-Line: From vygen@gmx.de Mon Jul 8 15:32:41 2002 Received: from issv0171.isis.de (issv0171.isis.de [195.158.131.223]) by postgresql.org (Postfix) with SMTP id 2D442476FEC for ; Mon, 8 Jul 2002 12:36:30 -0400 (EDT) Received: (qmail 18543 invoked by uid 1010); 8 Jul 2002 16:36:34 -0000 Received: from unknown (HELO janning.planwerk6.local) ([195.158.148.44]) (envelope-sender ) by mail.isis.de (qmail-ldap-1.03) with SMTP for ; 8 Jul 2002 16:36:34 -0000 Received: from there (localhost [127.0.0.1]) by janning.planwerk6.local (8.11.6/8.11.6/SuSE Linux 0.5) with SMTP id g68GaaX01778; Mon, 8 Jul 2002 18:36:36 +0200 Message-Id: <200207081636.g68GaaX01778@janning.planwerk6.local> Content-Type: text/plain; charset="iso-8859-1" From: Janning Vygen Organization: Planwerk 6 /websolutions To: teknokrat@yahoo.com (teknokrat), pgsql-sql@postgresql.org Subject: Re: manipulating the database in plsql Date: Mon, 8 Jul 2002 18:36:35 +0200 X-Mailer: KMail [version 1.3.1] References: <1cbae208.0207071040.1ba02f91@posting.google.com> In-Reply-To: <1cbae208.0207071040.1ba02f91@posting.google.com> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Spam-Status: No, hits=-2.3 required=5.0 tests=IN_REP_TO,MSG_ID_ADDED_BY_MTA_3 version=2.30 X-Spam-Level: X-Archive-Number: 200207/100 X-Sequence-Number: 8479 Am Sonntag, 7. Juli 2002 20:40 schrieb teknokrat: > Is there any way to work with tables etc, in plsql? Can i get a get > a database handle to the local database? If not, is there any > chance for this to be implemented in the near future? I guess you mean plpgsql. you dont need a database handle inside plpgsql. you just can do SQL operations or do other stuff like inserting, updating and so on (sometimes you need the plpgsql PERFORM statement). look at the programmers guide about procedural languages (plpgsql.html) janning