Marcos Borges wrote:
07/12/2006 04:31
*SQL_CALC_FOUND_ROWS in POSTGRESQL*
In mysqln i m using the command SQL_CALC_FOUND_ROWS in follow sintax.
SELECT SQL_CALC_FOUND_ROWS name, email, tel FROM mytable WHERE name <>
'' LIMIT 0, 10
to have the recorset data.
and
SELECT FOUND_ROWS();
to have the total of registers found.
I dont want to use the command count(*), because the performance will
fall down, depending of the quantyt of tables and "joins".
The Data base postgresql have something similar ???
Nope, you're out of luck sorry. That's a mysql-ism and I doubt postgres
will ever include something similar.
--
Postgresql & php tutorials
http://www.designmagick.com/
