Hi All,<br /><br />we are trying to modify the source code of postgresql to support a new command pivot <colA>
<colB><tablename><br />we are doing the following steps:<br />1. After parsing the input, we are able to
getthe values entered by the user for column A , column B and tablename. <br />2. Then, from postgresmain, we call
exec_simple_querywith a new query "select * from tablename"<br />3. Then we read the result of execution of this query
fromsendrowdescriptionmessage and printtup functions and also, don't allow these to send the result of the select query
tothe frontend <br />4. now, we do the required changes needed for the pivot command <br />5. after this, from
executorrun, we call sendrowdescriptionmessage function ( with modifications) to send the newly calculated row
description- this is working fine <br />6. Now, we want to send the newly calculated row data to the frontend. We are
notable to do this...<br />is there any way to send the row values, without invoking the executeplan again? - since
executeplanis overwriting the earlier sent rowdescription (which we are not able to figure out why ! ) <br /><br />Can
anyonehelp us? <br />we would be grateful, if you could give any pointers in this regard.<br /><br />Thanking you in
advance,<br/>Rose.<br /><br />