Re: Stored procedures vs Functions

> Stored procedures/functions are not able to return result sets. You might be
> able to use a combination of functions and views to accomplish your task in a
> similar way. Functions and stored procedures are interchangable when refering
> to postgres. You can write a stored procedure in any of several built in
> languages (PL == procedural language): PL/PgSQL, PL/perl, PL/python, PL/tcl;
> alternatively, you can make your own language (although that involves a
> considerable amount of effort).

Some people return results in temp tables, 7.2 will allow cursors to be
returned.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026