SQL_CALC_FOUND_ROWS equivalent in PostgreSQL

Поиск
Список
Период
Сортировка
От Matt Arnilo S. Baluyos (Mailing Lists)
Тема SQL_CALC_FOUND_ROWS equivalent in PostgreSQL
Дата
Msg-id d1a6d7930707301822geda34b2i1e558ccd84ca9513@mail.gmail.com
обсуждение исходный текст
Ответы Re: SQL_CALC_FOUND_ROWS equivalent in PostgreSQL  (Oliver Elphick <olly@lfix.co.uk>)
Список pgsql-novice
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.

В списке pgsql-novice по дате отправления:

Предыдущее
От: "Christian Leclerc"
Дата:
Сообщение: Auto-vacuum parameters (Postgres 8.2 on Windows Server 2003)
Следующее
От: Ronald Rojas
Дата:
Сообщение: alter table table add column