i'm reading the postgres documentation and i'm specifically
interested in creating stored procedures so that i can keep
as much of the business logic in the database as possible.
while reading 13.1.3 (SQL Functions on Composite Types) in
the Programmer's Guide i come across the phrase... "When calling a function that returns a row, we cannot retrieve
theentire row. We must either project an attribute out of the row or pass the entire row into another function.
SELECTname(new_emp()) AS nobody;"
how does this affect calling functions as stored procedures
from the jdbc driver and getting a result set returned bac?
am i allowed to use Connection.PrepareCall() to create a
CallableStatement against a postgres function and receive a
ResultSet that can be iterated over?
thanks!
rjsjr