Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E1603475AA1 for ; Mon, 2 Dec 2002 02:10:00 -0500 (EST) Received: from hotmail.com (f73.law14.hotmail.com [64.4.21.73]) by postgresql.org (Postfix) with ESMTP id 4F3714758F1 for ; Mon, 2 Dec 2002 02:10:00 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sun, 1 Dec 2002 23:10:00 -0800 Received: from 203.129.231.85 by lw14fd.law14.hotmail.msn.com with HTTP; Mon, 02 Dec 2002 07:10:00 GMT X-Originating-IP: [203.129.231.85] From: "Atul Pedgaonkar" To: pgsql-sql@postgresql.org Subject: Need Postgresql Help Date: Mon, 02 Dec 2002 07:10:00 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 02 Dec 2002 07:10:00.0355 (UTC) FILETIME=[D3FC7F30:01C299D1] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/4 X-Sequence-Number: 10592 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 paratmeters. ? 3)How to return resultset from that Stored Procedure ? I hope your kind co-operation. Thank You, Regards, Atul… _________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail