pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedNeed Postgresql Help
4+ messages / 4 participants
[nested] [flat]
* Need Postgresql Help
@ 2002-12-02 07:10 Atul Pedgaonkar <atulpedgaonkar@hotmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Atul Pedgaonkar @ 2002-12-02 07:10 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Need Postgresql Help
@ 2002-12-02 08:42 Andreas Joseph Krogh <andreak@officenet.no>
parent: Atul <atul@imcindia.net>
0 siblings, 1 reply; 4+ messages in thread
From: Andreas Joseph Krogh @ 2002-12-02 08:42 UTC (permalink / raw)
To: Atul <atul@imcindia.net>; pgsql-sql
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)
^ permalink raw reply [nested|flat] 4+ messages in thread
* Need Postgresql Help
@ 2002-12-02 08:44 Atul <atul@imcindia.net>
0 siblings, 1 reply; 4+ messages in thread
From: Atul @ 2002-12-02 08:44 UTC (permalink / raw)
To: pgsql-sql
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…
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Need Postgresql Help
@ 2002-12-02 10:57 Richard Huxton <dev@archonet.com>
parent: Andreas Joseph Krogh <andreak@officenet.no>
0 siblings, 0 replies; 4+ messages in thread
From: Richard Huxton @ 2002-12-02 10:57 UTC (permalink / raw)
To: Andreas Joseph Krogh <andreak@officenet.no>; Atul <atul@imcindia.net>; pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2002-12-02 10:57 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-12-02 07:10 Need Postgresql Help Atul Pedgaonkar <atulpedgaonkar@hotmail.com>
2002-12-02 08:44 Need Postgresql Help Atul <atul@imcindia.net>
2002-12-02 08:42 ` Andreas Joseph Krogh <andreak@officenet.no>
2002-12-02 10:57 ` Richard Huxton <dev@archonet.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox