Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL syntax rowcount value as an extra column in the result set - Mailing list pgsql-sql

From Thomas Kellerer
Subject Re: SQL syntax rowcount value as an extra column in the result set
Date
Msg-id hogm4r$gh6$1@dough.gmane.org
Whole thread Raw
In response to SQL syntax rowcount value as an extra column in the result set  ("Snyder, James" <jsnyde07@harris.com>)
Responses Re: SQL syntax rowcount value as an extra column in the result set  ("Jayadevan M" <Jayadevan.Maymala@ibsplc.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Snyder, James"
Date:
Subject: SQL syntax rowcount value as an extra column in the result set
Next
From: "Jayadevan M"
Date:
Subject: Re: SQL syntax rowcount value as an extra column in the result set