He had to write a () function returns the query result set, using pgaAdmin call shown below
Inquire on the net after the relevant documents found that need to add a line, you need to check out the column data to fill into the statement, can become like this after the query result set data


But behind each call shown in the figure is different, every time plus 9


Cause I can only manual query, can't write program inside, want to ask have met such a brother? Procedures should be on how to write

CodePudding user response:

Dynamic cursors () function returns the
The second line select results are returned to dynamic cursor name
According to this name, and then construct third row fetch statement

Function returns a cursor is an ancient method, if the result set field predictable, can use other statements directly to return the result, please see the manual