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

From: Jouriy LYSENKO <j(dot)lysenko(at)gmail(dot)com>
To: sergi(at)vladykin(dot)com
Cc: Sergi Vladykin <sergi(dot)vladykin(at)gmail(dot)com>, "Dmitry E(dot) Oboukhov" <unera(at)debian(dot)org>, pgsql-ru-general(at)postgresql(dot)org
Subject: Re: [pgsql-ru-general] Re: [pgsql-ru-general] аналог mysql'ного SQL_CALC_FOUND_ROWS
Date: 2011-03-20 12:33:18
Message-ID: AANLkTikL_c7DZkACYHyVFxe+FKiK7DYZNhCz-fscXr_6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ru-general

*Postgres*

*pg_numrows($result) **Works exactly the same as its MySQL counterpart*

2011/3/20 Sergi Vladykin <sergi(dot)vladykin(at)gmail(dot)com>

> Можно использовать windowing функцию count(*) over(). Подробнее см.
> http://www.postgresql.org/docs/current/static/tutorial-window.html
>
> regards,
> S.Vladykin
>
> --
> Sent via pgsql-ru-general mailing list (pgsql-ru-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-ru-general
>

--
Youri LYSENKO
•••••••••••••••••••••
Portable : +33671383176
Fax : +33826761768
Émail : j(dot)lysenko(at)gmail(dot)com

In response to

Browse pgsql-ru-general by date

  From Date Subject
Next Message Dmitriy MiksIr 2011-03-31 09:45:25 Re: системы репликации с регулируемой избыточностью, есть?
Previous Message Sergi Vladykin 2011-03-20 12:08:00 Re: [pgsql-ru-general] аналог mysql'ного SQL_CALC_FOUND_ROWS