On Feb 15, 2008, at 2:56 PM, Anton Andreev wrote:
Hi,
How do I return a result set? Is there a better way in 'plpgsql'
than the one described below?
I do not want to make a select from a function(which pretty useful
in many cases):
SELECT * FROM getfoo();
, but I want to just call the function with SELECT getfoo();
This article covers a way to do that: http://www.postgresonline.com/
journal/index.php?/categories/9-advanced.
Erik Jones
DBA | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
