Re: Row Count - Mailing list pgsql-novice

From Andreas Kretschmer
Subject Re: Row Count
Date
Msg-id 1294801499.20352.1360656182986.JavaMail.open-xchange@ox.ims-firmen.de
Whole thread Raw
In response to Row Count  (Sergey Gigoyan <sergey.gigoyan@gmail.com>)
Responses Re: Row Count  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-novice

Sergey Gigoyan <sergey.gigoyan@gmail.com> hat am 12. Februar 2013 um 08:05
geschrieben:
> How can I get selected row count in one statement?
> For example, I can do that by two select statements
>
> select id, name, addrress, (select count(*) from(select id


select id, name, ..., row_number() over () from ...

works since 8.4.


Andreas


pgsql-novice by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Row Count
Next
From: Sergey Konoplev
Date:
Subject: Re: Row Count