Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 3B9BD475AA1
	for <pgsql-sql@postgresql.org>; Mon,  2 Dec 2002 03:46:56 -0500 (EST)
Received: from krogh.officenet.no (unknown [193.212.174.47])
	by postgresql.org (Postfix) with ESMTP id 6523C475956
	for <pgsql-sql@postgresql.org>; Mon,  2 Dec 2002 03:46:55 -0500 (EST)
Received: from localhost.localdomain (localhost.localdomain [127.0.0.1])
	by krogh.officenet.no (Postfix) with ESMTP
	id 7A17C84DB3; Mon,  2 Dec 2002 03:42:42 -0500 (EST)
From: Andreas Joseph Krogh <andreak@officenet.no>
Organization: OfficeNet AS
To: "Atul" <atul@imcindia.net>, <pgsql-sql@postgresql.org>
Subject: Re: Need Postgresql Help
Date: Mon, 2 Dec 2002 09:42:41 +0100
User-Agent: KMail/1.5
References: <LHEOILFLDANINFJAGPEOIEFJCAAA.atul@imcindia.net>
In-Reply-To: <LHEOILFLDANINFJAGPEOIEFJCAAA.atul@imcindia.net>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200212020942.42094.andreak@officenet.no>
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200212/2
X-Sequence-Number: 10590

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

-- 
Andreas Joseph Krogh <andreak@officenet.no>
: What does this "kernel" program do?
- It does automated remote popcorn popping using XML-RPC to communicate
  bidirectionally with TCP/IP enabled microwave ovens.
  (Slashdot reply)