Hello everyone,
I would like to use PostgreSQL with the SmartyPaginate plugin of the
Smarty template engine.
In the examples on the documentation, the following two queries are used:
SELECT SQL_CALC_FOUND_ROWS * FROM mytable LIMIT X,Y
SELECT FOUND_ROWS() as total
What the SQL_CALC_FOUND_ROWS does is that it allows the FOUND_ROWS()
function to return the total rows if the first query didn't have the
LIMIT.
Is there an equivalent function in PostgreSQL for this or perhaps a workaround?
Thanks,
Matt
--
Stand before it and there is no beginning.
Follow it and there is no end.
Stay with the ancient Tao,
Move with the present.