Re: Call pl/sql function

Sangyoon Oh wrote:
> Hi,
>
> I am trying to call pl/sql function from jdbc, which is returns a
> table as a result set. Can anyone point out a help document?
> I have a Postgres book by by Ewald Geschwinde, but it doesn't
> cover much over pl/sql issue.
>
> Thanks,
>
> -Sangyoon Oh

When I wrote this text a long long time ago there was no way to work
with table functions yet and PL/pgSQL was not that good either. I hope
you still like the book :).

Here is some information about PL/pgSQL and table functions. You need
"RETURN NEXT".

http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html

Regards,

Hans

--
Cybertec Geschwinde u Schoenig
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/2952/30706; +43/664/233 90 75<
www.sapdb.at, www.cybertec.at, www.postgresql.at, kernel.cybertec.at