Re: Stored procs: PL/Tcl only? Settable privs for them? - Mailing list pgsql-general

From ryan
Subject Re: Stored procs: PL/Tcl only? Settable privs for them?
Date
Msg-id 396B61CB.B1924855@bel.bc.ca
Whole thread Raw
In response to Re: Stored procs: PL/Tcl only? Settable privs for them?  (Karel Zak <zakkr@zf.jcu.cz>)
List pgsql-general
Hi,


> > 2) Is CREATE FUNCTION pretty much a logical equivalent to CREATE
> > PROCEDURE in other RDBMSs?
>
> I not sure how it is in other DBs, but a little differention is here; in
> current state is not available create routines that retuns tuple.

Stored procs can returns tuples... but I'd like to know when can a
stored proc return a set not just a tuple?  I'd love to have stored
procs returning large record sets, or storing a huge query with multiple
set differences and subselects in a sql stored proc that way the query
plan can be done only once...

-ryan

--
Ryan Rawson
System Administrator
Binary Environments Ltd.
ryan@bel.bc.ca

pgsql-general by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Slashdot discussion
Next
From: Lamar Owen
Date:
Subject: Re: Slashdot discussion