Postgres Pro
Downloads
Home   >   mailing lists

Re: Row Count - Mailing list pgsql-novice

From Thomas Kellerer
Subject Re: Row Count
Date
Msg-id kfctqe$phm$1@ger.gmane.org
Whole thread Raw
In response to Re: Row Count  (Andreas Kretschmer <andreas@a-kretschmer.de>)
List pgsql-novice
Tree view 
Andreas Kretschmer, 12.02.2013 09:03:
> select id, name, ..., row_number() over () from ...
>
> works since 8.4.
>

That will only return the row count in the *last* row, not in all of them.

pgsql-novice by date:

Previous
From: Sergey Konoplev
Date:
Subject: Re: Row Count
Next
From: "Birchall, Austen"
Date:
Subject: GRANT USAGE ON DATABASE xxx TO public fails