Stored procedures/functions that can return recordsets...

Hello all,

This email is in regards to the following statement that I found just 
last week:

"PostgreSQL 7.3 is full of new, often requested features such as SQL '92 
schemas, prepared statements, and stored procedures that can return 
record sets."

The statement is part of a larger article and can be found about half 
way down the following article:

http://advocacy.postgresql.org/news/2002112801/

I am specifically interested in the portion of the statement that reads 
"stored procedures that can return record sets."  If this is indeed 
true, then I believe that PostgreSQL will become a much more used DB. 
This is one aspect that MS SQL Server and Oracle have had for some time 
that has been lacking from PostgreSQL (not to mention the Callable 
Statement JDBC driver support that is now included in version 7.3).

I am writing this to see if anyone has been able to successfully run a 
stored procedure (although it is probably still called a function) via 
Java (using a Callable Statement) and have it return a recordset (that 
is multiple columns and multiple rows).  If so, I would appreciate it if 
you could post a short example, both of the stored procedure and the 
Java code used to access it.

I have looked through the 7.3 documentation at the following link, but I 
have not found any references to this functionality.

http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/

I suspect that even in PostgreSQL version 7.3 no such thing as stored 
procedures exist - I suspect it was a misquote and the article is 
referring to functions.

In any event, I'd like to see this run for my own interest, it's not for 
a project.  I know what needs to be done in theory, so I'll tinker with 
it to try and get it to work on my own.  If anyone has any suggestions 
or has got this to work and would like to shed light on this, I would 
appreciate it.

Thank you kindly,
Pete