Re: SQL_CALC_FOUND_ROWS equivalent?

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