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.
[EMAIL PROTECTED]

Reply via email to