Thread: Need Postgresql Help
<div class="Section1"><p class="MsoNormal"><tt><font color="black" face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"CourierNew";color:black">Respected sir, </span></font></tt><font color="black" face="CourierNew" size="2"><span style="font-size:10.0pt;font-family: "Courier New";mso-fareast-font-family:"Courier New";color:black"><br /><tt> 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 </tt><br /><br /><tt> 1)How to create stored procedure in postgresql? </tt><br/><tt> 2)How can i use it from perl script with parameters. ? </tt><br /><tt> 3)How to return resultsetfrom that Stored Procedure ? </tt><br /><br /><tt>I hope your kind co-operation. </tt><br /><tt>Thank You, </tt><br/><br /><tt>Regards, </tt><br /><br /><tt>Atul…</tt></span></font><span class="EmailStyle15"><font color="black"face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: Arial"></span></font></span></div>
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)
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. -- Richard Huxton