Quote:
Originally Posted by rajapgsql
Hi,
Can anyone give any idea regarding how to read the result of execution of some query, tuple by tuple, from the backend, before it is sent to the client side?
for example, if the query is " select * from sometable; ", it is first parsed, and then send to the executor and then the final results are sent to the client side. Before this is done, the results of its execution must be present in some structure. Can anyone help me in finding out which is this structure and which is the function that enters the result tuples in to it?
~ raja
The three steps are PARSE,EXECUTE,FETCH.
Do you want to return the data record by record then you need to make use of a cursor.
