Re: SQL syntax rowcount value as an extra column in the result set

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL syntax rowcount value as an extra column in the result set
Date: 2010-03-25 21:55:41
Message-ID: hogm4r$gh6$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Snyder, James wrote on 25.03.2010 22:33:

> I’m using PostgreSQL (8.4.701)
There is no such version.
The current version is 8.4.3

> On a side note, Oracle allows the following syntax to achieve the above:
>
> select count(*) over () as ROWCOUNT , first_name from people
>
The same syntax will work on Postgres

Thomas

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jayadevan M 2010-03-26 03:35:00 Re: SQL syntax rowcount value as an extra column in the result set
Previous Message Snyder, James 2010-03-25 21:33:59 SQL syntax rowcount value as an extra column in the result set