Thank you Ying, sorry for late response. Could you (or somebody) help me with that UDF function? I would like the function do not affect the performance of the SELECT query. Thanks again. 2017-09-05 9:23 GMT-03:00 Ying Zhang :

Hai Alberto,

Nop, no such function ready-for-use. It should be easy to implement a UDF for this.

Jennie

...

On 1 Sep 2017, at 16:08, Alberto Ferrari wrote:

Hi, is there any function or trick in Monet equivalent to mysql "SELECT SQL_CALC_FOUND_ROWS ..." to get de total rows when limit is present ? ((pagination)

So I could get de TOTAL rows/pages number without exec another query everytime I need paginate results.

Thanks!

_______________________________________________ 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