function returning select result to JDBC

Started by giozhover 12 years ago2 messagesgeneral
Jump to latest
#1giozh
giozh@yahoo.it

I need to write a function (invoked by a jdbc client) that returns select
query result.
That function could return also set of row. How should i declare return type
of function?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/function-returning-select-result-to-JDBC-tp5763565.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#2Raghavendra
raghavendra.rao@enterprisedb.com
In reply to: giozh (#1)
Re: function returning select result to JDBC

On Fri, Jul 12, 2013 at 3:26 PM, giozh <giozh@yahoo.it> wrote:

I need to write a function (invoked by a jdbc client) that returns select
query result.
That function could return also set of row. How should i declare return
type
of function?

Bunch of examples here:
http://wiki.postgresql.org/wiki/Return_more_than_one_row_of_data_from_PL/pgSQL_functions

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/

Show quoted text

--
View this message in context:
http://postgresql.1045698.n5.nabble.com/function-returning-select-result-to-JDBC-tp5763565.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general