result sets from functions...

From: "Robert J(dot) Sanford, Jr(dot)" <rsanford(at)nolimitsystems(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: result sets from functions...
Date: 2001-08-15 02:35:56
Message-ID: HOEFIONAHHKFEFENBMNOEENNCAAA.rsanford@nolimitsystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 the entire row. We must either project an
attribute out of the row or pass the entire row into
another function.
SELECT name(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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-08-15 02:54:56 Re: result sets from functions...
Previous Message Paul McGarry 2001-08-15 01:12:47 Temp tables being written to disk. Avoidable?