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