Обсуждение: Need Postgresql Help

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