Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 37E13475FBE for ; Mon, 2 Dec 2002 03:34:50 -0500 (EST) Received: from ns2.imcindia.net (unknown [203.129.231.83]) by postgresql.org (Postfix) with ESMTP id 18626475F26 for ; Mon, 2 Dec 2002 03:34:38 -0500 (EST) Received: from virgo ([203.129.231.85]) by ns2.imcindia.net (8.9.3/8.9.3) with SMTP id OAA04670 for ; Mon, 2 Dec 2002 14:16:52 +0530 From: "Atul" To: Subject: Need Postgresql Help Date: Mon, 2 Dec 2002 14:14:09 +0530 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0000_01C29A0D.14CDF710" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200212/1 X-Sequence-Number: 10589 This is a multi-part message in MIME format. ------=_NextPart_000_0000_01C29A0D.14CDF710 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit 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 ? I hope your kind co-operation. Thank You, Regards, Atul… ------=_NextPart_000_0000_01C29A0D.14CDF710 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

= 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 procedur= e. The problem is like this

        1)How to create stored proce= dure in postgresql?
        2)How can i use it from perl script with parameters. ?
        3)How to return resultset fr= om that Stored Procedure ?

I hope your kind co-operation.
Thank You,

Regards,

Atul…

------=_NextPart_000_0000_01C29A0D.14CDF710--