Hi Martin, Is there an example of this in the documentation? I think it would be very helpful to have a guide of best practice when porting cursor based code although I'm not sure that is possible in general? Best regards, Alastair ________________________________________ From: users-list <users-list-bounces+a.mckinley=analyticsengines.com@monetdb.org> on behalf of Martin Kersten <Martin.Kersten@cwi.nl> Sent: 31 March 2014 13:35 To: Communication channel for MonetDB users Subject: 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
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list