5 Sep
2017
5 Sep
'17
12:23 p.m.
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 aferrari@starconnecting.com 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