result sets from functions...

Поиск
Список
Период
Сортировка
От Robert J. Sanford, Jr.
Тема result sets from functions...
Дата
Msg-id HOEFIONAHHKFEFENBMNOEENPCAAA.rsanford@nolimitsystems.com
обсуждение исходный текст
Список pgsql-jdbc
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


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Bryan Field-Elliot
Дата:
Сообщение: How to read PG Circle and Point types from JDBC?
Следующее
От: "Arnaud ESPANEL"
Дата:
Сообщение: Postgresql 7.1.2 and StarOffice 5.2