Home > mailing lists

Re: [pgsql-ru-general] аналог mysql'ного SQL_CALC_FOUND_ROWS - Mailing list pgsql-ru-general

From	Sergi Vladykin
Subject	Re: [pgsql-ru-general] аналог mysql'ного SQL_CALC_FOUND_ROWS
Date	March 20, 2011 18:08:00
Msg-id	AANLkTikFRua0SkcxBYSQUvJ-Ko-jF1ywK88sP4sqeTLu@mail.gmail.com Whole thread Raw
In response to	Re: аналог mysql'ного SQL_CALC_FOUND_ROWS ("Andrey N. Oktyabrski" <ano@bestmx.ru>)
Responses	Re: [pgsql-ru-general] Re: [pgsql-ru-general] аналог mysql'ного SQL_CALC_FOUND_ROWS
List	pgsql-ru-general

Tree view

Можно использовать windowing функцию count(*) over(). Подробнее см.
http://www.postgresql.org/docs/current/static/tutorial-window.html

regards,
S.Vladykin

pgsql-ru-general by date:

From: "Dmitry E. Oboukhov"
Date: 20 March 2011, 18:05:15
Subject: Re: аналог mysql'ного SQL_CALC_FOUND_ROWS

From: Jouriy LYSENKO
Date: 20 March 2011, 18:33:18
Subject: Re: [pgsql-ru-general] Re: [pgsql-ru-general] аналог mysql'ного SQL_CALC_FOUND_ROWS

Re: [pgsql-ru-general] аналог mysql'ного SQL_CALC_FOUND_ROWS - Mailing list pgsql-ru-general

Previous

Next