Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 73D4D4758F1 for ; Mon, 2 Dec 2002 05:57:17 -0500 (EST) Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net [194.217.242.85]) by postgresql.org (Postfix) with ESMTP id 6DF7C47616D for ; Mon, 2 Dec 2002 05:57:10 -0500 (EST) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-35.mail.demon.net with esmtp (Exim 3.36 #2) id 18IoGD-00010f-0U; Mon, 02 Dec 2002 10:57:09 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by mainbox.archonet.com (Postfix) with ESMTP id 9D67D16ECE; Mon, 2 Dec 2002 10:57:07 +0000 (GMT) Received: from client.archonet.com (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with ESMTP id 05B8F1647B; Mon, 2 Dec 2002 10:57:06 +0000 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton Organization: Archonet Ltd To: Andreas Joseph Krogh , "Atul" , Subject: Re: Need Postgresql Help Date: Mon, 2 Dec 2002 10:57:09 +0000 User-Agent: KMail/1.4.3 References: <200212020942.42094.andreak@officenet.no> In-Reply-To: <200212020942.42094.andreak@officenet.no> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200212021057.09806.dev@archonet.com> X-Virus-Scanned: by AMaViS snapshot-20020531 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/3 X-Sequence-Number: 10591 On Monday 02 Dec 2002 8:42 am, Andreas Joseph Krogh wrote: > On Monday 02 December 2002 09:44, Atul wrote: > > Respected sir, > > Atul Pedgaonkar here from India. I am using postgresql7.2 = as > > backend and for front-end, perl5.6.1. I need some help regarding > > postgresql-stored procedure. The problem is like this > > > > 1)How to create stored procedure in postgresql? > > 2)How can i use it from perl script with parameters. ? > > 3)How to return resultset from that Stored Procedure ? > > You need 7.3 to do 3). > Infor on stored procedures: > $INSTALLDIR/doc/html/plpgsql.html 1. See the manual chapter on "procedural languages" - plpgsql, pltcl, plperl Also see http://techdocs.postgresql.org 2. Exactly as with any other query 3. Either upgrade to 7.3 (as above) or return a cursor from the function. --=20 Richard Huxton