Re: Cycling through cursor in a procedure

"highest numbers from a table which total falls under certain threshold" do you mean by any chance mean something like select max(MyAttribute) from MyTable where MyAttribute < MyThreshold; ? If so, no cursors required here ... ;-) apologies, in case I missed your point ... Stefan ----- Original Message -----

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 on behalf of Martin Kersten 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 _______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |