Re: Row Count

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Row Count
Date: 2013-02-12 08:18:12
Message-ID: kfctqe$phm$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Birchall, Austen 2013-02-12 11:36:27 GRANT USAGE ON DATABASE xxx TO public fails
Previous Message Sergey Konoplev 2013-02-12 08:07:21 Re: Row Count