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

From: Sergi Vladykin <sergi(dot)vladykin(at)gmail(dot)com>
To: "Dmitry E(dot) Oboukhov" <unera(at)debian(dot)org>
Cc: pgsql-ru-general(at)postgresql(dot)org
Subject: Re: [pgsql-ru-general] аналог mysql'ного SQL_CALC_FOUND_ROWS
Date: 2011-03-20 12:08:00
Message-ID: AANLkTikFRua0SkcxBYSQUvJ-Ko-jF1ywK88sP4sqeTLu@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ru-general

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

regards,
S.Vladykin

In response to

Responses

Browse pgsql-ru-general by date

  From Date Subject
Next Message Jouriy LYSENKO 2011-03-20 12:33:18 Re: [pgsql-ru-general] Re: [pgsql-ru-general] аналог mysql'ного SQL_CALC_FOUND_ROWS
Previous Message Dmitry E. Oboukhov 2011-03-20 12:05:15 Re: аналог mysql'ного SQL_CALC_FOUND_ROWS