Re: Cycling through cursor in a procedure

Hi MonetDB SQL does not support the CURSOR concept in SQL. For that you could consider using your own key-based cursor generator function. regards, Martin On 31/03/14 14:32, Radovan Bičiště wrote:

Hello, Please is there a flow control syntax for cycling through rows in a cursor in a procedure? I can not find any other solution to how to select highest numbers from a table which total falls under certain threshold. :( I have a function that returns sorted rows and can be used as a subquery and I did not get further ... Thank you, Radovan _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list