how to declare the cursors in a stored procedural function

[san1014]

Hi
I have few questions.
Pleae give me the answers.
1) In postgreSQL, how to declare and call the cursors in a stored procedural function?
Ex: I want to display all the columns in a table in one cursor
and also how to see the output.
2) tell me , the analytic functions in oracle connect by prior,
sys_connect_by_ path are existed in postgreSQL?
3)how to call the stored procedural function which was written in postgres in java?

Thank you

[rski]

Hi
I have few questions.
Pleae give me the answers.
1) In postgreSQL, how to declare and call the cursors in a stored procedural function?
Ex: I want to display all the columns in a table in one cursor
and also how to see the output.
2) tell me , the analytic functions in oracle connect by prior,
sys_connect_by_ path are existed in postgreSQL?
3)how to call the stored procedural function which was written in postgres in java?

Thank you

Ad 1) for cursors see here
Ad 2) i'm sorry i don't know what are you talking about, i don't know oracle
Ad 3) what do you mean saying "written in postgres in java"? you mean written in pljava? if so i think you can call it like every other function usually using select command.

[debasisdas]

Hi
I have few questions.
Pleae give me the answers.
1) In postgreSQL, how to declare and call the cursors in a stored procedural function?
............... ......

Your questions are too much theoritical and is beyond the scope of this discussion . Please refer some good books for the purpose or you can easily find all that by investing some quality time in web searching.