From jsnyde07@harris.com Thu Mar  25 21:51:26 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 0486B63310E
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 18:51:26 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 86461-08 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 21:51:13 +0000 (UTC)
X-Greylist: delayed 00:17:10.7869 by SQLgrey-1.7.6
Received: from mlbe2k1.cs.myharris.net (mlbe2k1.cs.myharris.net
	[137.237.90.88])
	by mail.postgresql.org (Postfix) with ESMTP id E25356330DF
	for <pgsql-sql@postgresql.org>; Thu, 25 Mar 2010 18:51:13 -0300 (ADT)
Received: from mail pickup service by mlbe2k1.cs.myharris.net with Microsoft
	SMTPSVC; Thu, 25 Mar 2010 17:33:59 -0400
Received: from mlbe2k10.cs.myharris.net ([137.237.89.92]) by
	mlbe2k1.cs.myharris.net with Microsoft SMTPSVC(6.0.3790.3959);
	Thu, 25 Mar 2010 17:33:59 -0400
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01CACC62.E12C0422"
Subject: SQL syntax rowcount value as an extra column in the result set
Date: Thu, 25 Mar 2010 17:33:59 -0400
Message-ID: <594D625E4784AD4EA9D423E292BE6725489FD1@mlbe2k10.cs.myharris.net>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: SQL syntax rowcount value as an extra column in the result set
Thread-Index: AcrMYvl5wtIuk2pyRbGlzBup0EZIng==
From: "Snyder, James" <jsnyde07@harris.com>
To: <pgsql-sql@postgresql.org>
X-OriginalArrivalTime: 25 Mar 2010 21:33:59.0206 (UTC)
	FILETIME=[E149EC60:01CACC62]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.109 tagged_above=-10 required=5
	tests=BAYES_05=-1.11, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201003/195
X-Sequence-Number: 33902

This is a multi-part message in MIME format.

------_=_NextPart_001_01CACC62.E12C0422
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hello

I'm using PostgreSQL (8.4.701) and Java (jdbc,
postgresql-8.4-701.jdbc4.jar) to connect to the database.

My question is: what is the SQL syntax for PostgreSQL to achieve the
following:

I want to receive the rowcount along with the rest of a result set. For
example, let's say the following query returns

select first_name from people;

first_name
=3D=3D=3D=3D=3D=3D=3D=3D=3D
Mary
Sue
Joe


and the following query returns the value=20

select count(*)as ROWCOUNT from people;
ROWCOUNT
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
3
3


What I'm looking for is the output as

ROWCOUNT ,  first_name
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
3 , Mary
3 , Sue
3 , Joe

so I can use JDBC (snip-it) as follows:

resultSet.getInt("ROWCOUNT")
resultSet.getString("first_name")

On a side note, Oracle allows the following syntax to achieve the above:

select count(*) over () as ROWCOUNT , first_name from people

Thanks,Jim


------_=_NextPart_001_01CACC62.E12C0422
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7654.12">
<TITLE>SQL syntax rowcount value as an extra column in the result =
set</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">Hello</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">I</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">&#8217;</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">m =
using PostgreSQL (8.4.701) and Java (jdbc</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"><FONT FACE=3D"Calibri">,</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"> =
<FONT FACE=3D"Calibri">postgresql-8.4-701.jdbc4.jar</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"><FONT FACE=3D"Calibri">) to connect to the =
database.</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">My question =
is:</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri"> what =
is the SQL syntax for PostgreSQL to achieve the =
following:</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">I want to =
receive the rowcount along with the rest of a result set. For example, =
let</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">&#8217;</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">s say =
the following query returns</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">select =
first_name from people</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">;</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">first_name</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">Mary</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">Sue</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">Joe</FONT></SPAN></P>
<BR>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">and the =
following query returns the value</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"> =
</SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">select =
count(*)</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">as =
ROWCOUNT</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri"></FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"> <FONT FACE=3D"Calibri">from =
people</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">;</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">ROWCOUNT</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">3</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">3</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">What =
I</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">&#8217;</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">m =
looking for is the output as</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">ROWCOUNT ,&nbsp; first_name</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">3 , =
Mary</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">3 , =
Sue</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">3 , =
Joe</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">so I can use =
JDBC (snip-it) as follows:</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">resultSet.getInt(</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"><FONT FACE=3D"Calibri">&#8220;</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"><FONT FACE=3D"Calibri">ROWCOUNT</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"><FONT FACE=3D"Calibri">&#8221;</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"><FONT FACE=3D"Calibri">)</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">resultSet.getString(</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"><FONT FACE=3D"Calibri">&#8220;</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"><FONT FACE=3D"Calibri">first_name</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"><FONT FACE=3D"Calibri">&#8221;</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"><FONT FACE=3D"Calibri">)</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">On a =
side note,</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"> <FONT =
FACE=3D"Calibri">Oracle allows the following</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"> =
<FONT FACE=3D"Calibri">syntax</FONT></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"><FONT FACE=3D"Calibri"> to achieve the =
above</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">:</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri">select =
count(*)</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT FACE=3D"Calibri"> over =
()</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"> <FONT FACE=3D"Calibri">as =
ROWCOUNT</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri"></FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"> <FONT FACE=3D"Calibri">, =
first_name</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"> <FONT FACE=3D"Calibri">from =
people</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">Thank</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">s,</FONT></SPAN><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"><FONT =
FACE=3D"Calibri">Jim</FONT></SPAN></P>

<P DIR=3DLTR><SPAN LANG=3D"en-us"></SPAN><SPAN =
LANG=3D"en-us"></SPAN><SPAN LANG=3D"en-us"></SPAN></P>

</BODY>
</HTML>
------_=_NextPart_001_01CACC62.E12C0422--



From spam_eater@gmx.net Thu Mar  25 21:56:08 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 5293F6330DF
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 18:56:08 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 87630-02 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 21:55:57 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from lo.gmane.org (lo.gmane.org [80.91.229.12])
	by mail.postgresql.org (Postfix) with ESMTP id CF4C963310E
	for <pgsql-sql@postgresql.org>; Thu, 25 Mar 2010 18:55:57 -0300 (ADT)
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1Nuv1t-0001Da-Ma
	for pgsql-sql@postgresql.org; Thu, 25 Mar 2010 22:55:53 +0100
Received: from ppp-188-174-82-106.dynamic.mnet-online.de ([188.174.82.106])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Thu, 25 Mar 2010 22:55:53 +0100
Received: from spam_eater by ppp-188-174-82-106.dynamic.mnet-online.de with
	local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Thu, 25 Mar 2010 22:55:53 +0100
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-sql@postgresql.org
From: Thomas Kellerer <spam_eater@gmx.net>
Subject: Re: SQL syntax rowcount value as an extra column in the result set
Date: Thu, 25 Mar 2010 22:55:41 +0100
Lines: 14
Message-ID: <hogm4r$gh6$1@dough.gmane.org>
References: <594D625E4784AD4EA9D423E292BE6725489FD1@mlbe2k10.cs.myharris.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
X-Complaints-To: usenet@dough.gmane.org
X-Gmane-NNTP-Posting-Host: ppp-188-174-82-106.dynamic.mnet-online.de
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de;
	rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666
In-Reply-To: <594D625E4784AD4EA9D423E292BE6725489FD1@mlbe2k10.cs.myharris.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001
X-Spam-Level: 
X-Archive-Number: 201003/196
X-Sequence-Number: 33903

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




From Jayadevan.Maymala@ibsplc.com Fri Mar  26 03:35:21 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 99DE0632309;
	Fri, 26 Mar 2010 00:35:21 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024)
	with ESMTP id 47949-01; Fri, 26 Mar 2010 03:35:10 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mx1.ibsplc.com (mx1.ibsplc.com [202.177.44.5])
	by mail.postgresql.org (Postfix) with ESMTP id AEFCB6321D3;
	Fri, 26 Mar 2010 00:35:08 -0300 (ADT)
X-IronPort-AV: E=Sophos;i="4.51,311,1267381800"; d="scan'208";a="13921508"
Received: from unknown (HELO Green.ibsplc.com) ([192.168.0.4])
	by mx2.ibsplc.com with ESMTP; 26 Mar 2010 08:48:04 +0530
In-Reply-To: <594D625E4784AD4EA9D423E292BE6725489FD1@mlbe2k10.cs.myharris.net>
To: "Snyder, James" <jsnyde07@harris.com>
Cc: pgsql-sql@postgresql.org,pgsql-sql-owner@postgresql.org
Subject: Re: SQL syntax rowcount value as an extra column in the result set
Message-ID: 
 <OF5A2D0504.FE37F1EE-ON652576F2.00139075-652576F2.00138CC0@LocalDomain>
From: "Jayadevan M" <Jayadevan.Maymala@ibsplc.com>
Date: Fri, 26 Mar 2010 09:05:00 +0530
Content-Type: multipart/alternative;
	boundary="=_alternative 00138CBE652576F2_="
References: <594D625E4784AD4EA9D423E292BE6725489FD1@mlbe2k10.cs.myharris.net>
MIME-Version: 1.0
X-KeepSent: 5A2D0504:FE37F1EE-652576F2:00139075; name=$KeepSent; type=4
X-Mailer: Lotus Notes Release 8.5 December 05, 2008
X-Disclaimed: 23859
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.002 tagged_above=-10 required=5
	tests=BAYES_50=0.001, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201003/197
X-Sequence-Number: 33904


--=_alternative 00138CBE652576F2_=
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: base64

SGksDQpJcyB0aGlzIHdoYXQgeW91IGFyZSB0cnlpbmcgdG8gZG8/DQpwb3N0Z3Jlcz0jIHNlbGVj
dCAqIGZyb20gKHNlbGVjdCBjb3VudCgqKSBmcm9tIHBlb3BsZSApIHAsIChzZWxlY3QgDQpmaXJz
dG5hbWUgZnJvbSBwZW9wbGUpcDI7DQogY291bnQgfCBmaXJzdG5hbWUNCi0tLS0tLS0rLS0tLS0t
LS0tLS0NCiAgICAgNSB8IE1hcnkNCiAgICAgNSB8IE1hcnkNCiAgICAgNSB8IEpvaG4NCiAgICAg
NSB8IEpvaG4NCiAgICAgNSB8IEphY29iDQooNSByb3dzKQ0KSSBkbyBub3Qga25vdyBhYm91dCB0
aGUgcGVyZm9ybWFuY2UgaW1wYWN0IG9mIHN1Y2ggYSBxdWVyeSAoY2FydGVzaWFuIA0Kam9pbikN
ClJlZ2FyZHMsDQpKYXlhZGV2YW4NCg0KDQoNCg0KRnJvbTogICAiU255ZGVyLCBKYW1lcyIgPGpz
bnlkZTA3QGhhcnJpcy5jb20+DQpUbzogICAgIDxwZ3NxbC1zcWxAcG9zdGdyZXNxbC5vcmc+DQpE
YXRlOiAgIDI2LzAzLzIwMTAgMDM6MjENClN1YmplY3Q6ICAgICAgICBbU1FMXSBTUUwgc3ludGF4
IHJvd2NvdW50IHZhbHVlIGFzIGFuIGV4dHJhIGNvbHVtbiBpbiB0aGUgDQpyZXN1bHQgc2V0DQpT
ZW50IGJ5OiAgICAgICAgcGdzcWwtc3FsLW93bmVyQHBvc3RncmVzcWwub3JnDQoNCg0KDQpIZWxs
bw0KSeKAmW0gdXNpbmcgUG9zdGdyZVNRTCAoOC40LjcwMSkgYW5kIEphdmEgKGpkYmMsIA0KcG9z
dGdyZXNxbC04LjQtNzAxLmpkYmM0LmphcikgdG8gY29ubmVjdCB0byB0aGUgZGF0YWJhc2UuDQpN
eSBxdWVzdGlvbiBpczogd2hhdCBpcyB0aGUgU1FMIHN5bnRheCBmb3IgUG9zdGdyZVNRTCB0byBh
Y2hpZXZlIHRoZSANCmZvbGxvd2luZzoNCkkgd2FudCB0byByZWNlaXZlIHRoZSByb3djb3VudCBh
bG9uZyB3aXRoIHRoZSByZXN0IG9mIGEgcmVzdWx0IHNldC4gRm9yIA0KZXhhbXBsZSwgbGV04oCZ
cyBzYXkgdGhlIGZvbGxvd2luZyBxdWVyeSByZXR1cm5zDQpzZWxlY3QgZmlyc3RfbmFtZSBmcm9t
IHBlb3BsZTsNCmZpcnN0X25hbWUNCj09PT09PT09PQ0KTWFyeQ0KU3VlDQpKb2UNCg0KYW5kIHRo
ZSBmb2xsb3dpbmcgcXVlcnkgcmV0dXJucyB0aGUgdmFsdWUgDQpzZWxlY3QgY291bnQoKilhcyBS
T1dDT1VOVCBmcm9tIHBlb3BsZTsNClJPV0NPVU5UDQo9PT09PT09PT09DQozDQozDQpXaGF0IEni
gJltIGxvb2tpbmcgZm9yIGlzIHRoZSBvdXRwdXQgYXMNClJPV0NPVU5UICwgIGZpcnN0X25hbWUN
Cj09PT09PT09PT09PT09PT09PT09PQ0KMyAsIE1hcnkNCjMgLCBTdWUNCjMgLCBKb2UNCnNvIEkg
Y2FuIHVzZSBKREJDIChzbmlwLWl0KSBhcyBmb2xsb3dzOg0KcmVzdWx0U2V0LmdldEludCjigJxS
T1dDT1VOVOKAnSkNCnJlc3VsdFNldC5nZXRTdHJpbmco4oCcZmlyc3RfbmFtZeKAnSkNCk9uIGEg
c2lkZSBub3RlLCBPcmFjbGUgYWxsb3dzIHRoZSBmb2xsb3dpbmcgc3ludGF4IHRvIGFjaGlldmUg
dGhlIGFib3ZlOg0Kc2VsZWN0IGNvdW50KCopIG92ZXIgKCkgYXMgUk9XQ09VTlQgLCBmaXJzdF9u
YW1lIGZyb20gcGVvcGxlDQpUaGFua3MsSmltDQoNCkRJU0NMQUlNRVI6ICAgIlRoZSBpbmZvcm1h
dGlvbiBpbiB0aGlzIGUtbWFpbCBhbmQgYW55IGF0dGFjaG1lbnQgaXMgaW50ZW5kZWQgb25seSBm
b3IgdGhlIHBlcnNvbiB0byB3aG9tIGl0IGlzIGFkZHJlc3NlZCBhbmQgbWF5IGNvbnRhaW4gY29u
ZmlkZW50aWFsIGFuZC9vciBwcml2aWxlZ2VkIG1hdGVyaWFsLiBJZiB5b3UgaGF2ZSByZWNlaXZl
ZCB0aGlzIGUtbWFpbCBpbiBlcnJvciwga2luZGx5IGNvbnRhY3QgdGhlIHNlbmRlciBhbmQgZGVz
dHJveSBhbGwgY29waWVzIG9mIHRoZSBvcmlnaW5hbCBjb21tdW5pY2F0aW9uLiBJQlMgbWFrZXMg
bm8gd2FycmFudHksIGV4cHJlc3Mgb3IgaW1wbGllZCwgbm9yIGd1YXJhbnRlZXMgdGhlIGFjY3Vy
YWN5LCBhZGVxdWFjeSBvciBjb21wbGV0ZW5lc3Mgb2YgdGhlIGluZm9ybWF0aW9uIGNvbnRhaW5l
ZCBpbiB0aGlzIGVtYWlsIG9yIGFueSBhdHRhY2htZW50IGFuZCBpcyBub3QgbGlhYmxlIGZvciBh
bnkgZXJyb3JzLCBkZWZlY3RzLCBvbWlzc2lvbnMsIHZpcnVzZXMgb3IgZm9yIHJlc3VsdGFudCBs
b3NzIG9yIGRhbWFnZSwgaWYgYW55LCBkaXJlY3Qgb3IgaW5kaXJlY3QuIiA=

--=_alternative 00138CBE652576F2_=
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: base64

PGZvbnQgc2l6ZT0yIGZhY2U9InNhbnMtc2VyaWYiPkhpLDwvZm9udD48YnI+PGZvbnQgc2l6ZT0y
IGZhY2U9InNhbnMtc2VyaWYiPklzIHRoaXMgd2hhdCB5b3UgYXJlIHRyeWluZyB0byBkbz88L2Zv
bnQ+PGJyPjxmb250IHNpemU9MiBmYWNlPSJzYW5zLXNlcmlmIj5wb3N0Z3Jlcz0jIHNlbGVjdCAq
IGZyb20gKHNlbGVjdCBjb3VudCgqKQ0KZnJvbSBwZW9wbGUgKSBwLCAoc2VsZWN0IGZpcnN0bmFt
ZSBmcm9tIHBlb3BsZSlwMjs8L2ZvbnQ+PGJyPjxmb250IHNpemU9MiBmYWNlPSJzYW5zLXNlcmlm
Ij4mbmJzcDtjb3VudCB8IGZpcnN0bmFtZTwvZm9udD48YnI+PGZvbnQgc2l6ZT0yIGZhY2U9InNh
bnMtc2VyaWYiPi0tLS0tLS0rLS0tLS0tLS0tLS08L2ZvbnQ+PGJyPjxmb250IHNpemU9MiBmYWNl
PSJzYW5zLXNlcmlmIj4mbmJzcDsgJm5ic3A7ICZuYnNwOzUgfCBNYXJ5PC9mb250Pjxicj48Zm9u
dCBzaXplPTIgZmFjZT0ic2Fucy1zZXJpZiI+Jm5ic3A7ICZuYnNwOyAmbmJzcDs1IHwgTWFyeTwv
Zm9udD48YnI+PGZvbnQgc2l6ZT0yIGZhY2U9InNhbnMtc2VyaWYiPiZuYnNwOyAmbmJzcDsgJm5i
c3A7NSB8IEpvaG48L2ZvbnQ+PGJyPjxmb250IHNpemU9MiBmYWNlPSJzYW5zLXNlcmlmIj4mbmJz
cDsgJm5ic3A7ICZuYnNwOzUgfCBKb2huPC9mb250Pjxicj48Zm9udCBzaXplPTIgZmFjZT0ic2Fu
cy1zZXJpZiI+Jm5ic3A7ICZuYnNwOyAmbmJzcDs1IHwgSmFjb2I8L2ZvbnQ+PGJyPjxmb250IHNp
emU9MiBmYWNlPSJzYW5zLXNlcmlmIj4oNSByb3dzKTwvZm9udD48YnI+PGZvbnQgc2l6ZT0yIGZh
Y2U9InNhbnMtc2VyaWYiPkkgZG8gbm90IGtub3cgYWJvdXQgdGhlIHBlcmZvcm1hbmNlDQppbXBh
Y3Qgb2Ygc3VjaCBhIHF1ZXJ5IChjYXJ0ZXNpYW4gam9pbik8L2ZvbnQ+PGJyPjxmb250IHNpemU9
MiBmYWNlPSJzYW5zLXNlcmlmIj5SZWdhcmRzLDwvZm9udD48YnI+PGZvbnQgc2l6ZT0yIGZhY2U9
IlRyZWJ1Y2hldCBNUyI+SmF5YWRldmFuPC9mb250Pjxicj48YnI+PGJyPjxicj48YnI+PGZvbnQg
c2l6ZT0xIGNvbG9yPSM1ZjVmNWYgZmFjZT0ic2Fucy1zZXJpZiI+RnJvbTogJm5ic3A7ICZuYnNw
OyAmbmJzcDsNCiZuYnNwOzwvZm9udD48Zm9udCBzaXplPTEgZmFjZT0ic2Fucy1zZXJpZiI+JnF1
b3Q7U255ZGVyLCBKYW1lcyZxdW90Ow0KJmx0O2pzbnlkZTA3QGhhcnJpcy5jb20mZ3Q7PC9mb250
Pjxicj48Zm9udCBzaXplPTEgY29sb3I9IzVmNWY1ZiBmYWNlPSJzYW5zLXNlcmlmIj5UbzogJm5i
c3A7ICZuYnNwOyAmbmJzcDsNCiZuYnNwOzwvZm9udD48Zm9udCBzaXplPTEgZmFjZT0ic2Fucy1z
ZXJpZiI+Jmx0O3Bnc3FsLXNxbEBwb3N0Z3Jlc3FsLm9yZyZndDs8L2ZvbnQ+PGJyPjxmb250IHNp
emU9MSBjb2xvcj0jNWY1ZjVmIGZhY2U9InNhbnMtc2VyaWYiPkRhdGU6ICZuYnNwOyAmbmJzcDsg
Jm5ic3A7DQombmJzcDs8L2ZvbnQ+PGZvbnQgc2l6ZT0xIGZhY2U9InNhbnMtc2VyaWYiPjI2LzAz
LzIwMTAgMDM6MjE8L2ZvbnQ+PGJyPjxmb250IHNpemU9MSBjb2xvcj0jNWY1ZjVmIGZhY2U9InNh
bnMtc2VyaWYiPlN1YmplY3Q6ICZuYnNwOyAmbmJzcDsNCiZuYnNwOyAmbmJzcDs8L2ZvbnQ+PGZv
bnQgc2l6ZT0xIGZhY2U9InNhbnMtc2VyaWYiPltTUUxdIFNRTCBzeW50YXgNCnJvd2NvdW50IHZh
bHVlIGFzIGFuIGV4dHJhIGNvbHVtbiBpbiB0aGUgcmVzdWx0IHNldDwvZm9udD48YnI+PGZvbnQg
c2l6ZT0xIGNvbG9yPSM1ZjVmNWYgZmFjZT0ic2Fucy1zZXJpZiI+U2VudCBieTogJm5ic3A7ICZu
YnNwOw0KJm5ic3A7ICZuYnNwOzwvZm9udD48Zm9udCBzaXplPTEgZmFjZT0ic2Fucy1zZXJpZiI+
cGdzcWwtc3FsLW93bmVyQHBvc3RncmVzcWwub3JnPC9mb250Pjxicj48aHIgbm9zaGFkZT48YnI+
PGJyPjxicj48Zm9udCBzaXplPTMgZmFjZT0iQ2FsaWJyaSI+SGVsbG88L2ZvbnQ+PHA+PGZvbnQg
c2l6ZT0zIGZhY2U9IkNhbGlicmkiPknigJltIHVzaW5nIFBvc3RncmVTUUwgKDguNC43MDEpIGFu
ZCBKYXZhDQooamRiYyw8L2ZvbnQ+PGZvbnQgc2l6ZT0zPiA8L2ZvbnQ+PGZvbnQgc2l6ZT0zIGZh
Y2U9IkNhbGlicmkiPnBvc3RncmVzcWwtOC40LTcwMS5qZGJjNC5qYXIpDQp0byBjb25uZWN0IHRv
IHRoZSBkYXRhYmFzZS48L2ZvbnQ+PHA+PGZvbnQgc2l6ZT0zIGZhY2U9IkNhbGlicmkiPk15IHF1
ZXN0aW9uIGlzOiB3aGF0IGlzIHRoZSBTUUwgc3ludGF4IGZvcg0KUG9zdGdyZVNRTCB0byBhY2hp
ZXZlIHRoZSBmb2xsb3dpbmc6PC9mb250PjxwPjxmb250IHNpemU9MyBmYWNlPSJDYWxpYnJpIj5J
IHdhbnQgdG8gcmVjZWl2ZSB0aGUgcm93Y291bnQgYWxvbmcgd2l0aA0KdGhlIHJlc3Qgb2YgYSBy
ZXN1bHQgc2V0LiBGb3IgZXhhbXBsZSwgbGV04oCZcyBzYXkgdGhlIGZvbGxvd2luZyBxdWVyeSBy
ZXR1cm5zPC9mb250PjxwPjxmb250IHNpemU9MyBmYWNlPSJDYWxpYnJpIj5zZWxlY3QgZmlyc3Rf
bmFtZSBmcm9tIHBlb3BsZTs8L2ZvbnQ+PHA+PGZvbnQgc2l6ZT0zIGZhY2U9IkNhbGlicmkiPmZp
cnN0X25hbWU8L2ZvbnQ+PHA+PGZvbnQgc2l6ZT0zIGZhY2U9IkNhbGlicmkiPj09PT09PT09PTwv
Zm9udD48cD48Zm9udCBzaXplPTMgZmFjZT0iQ2FsaWJyaSI+TWFyeTwvZm9udD48cD48Zm9udCBz
aXplPTMgZmFjZT0iQ2FsaWJyaSI+U3VlPC9mb250PjxwPjxmb250IHNpemU9MyBmYWNlPSJDYWxp
YnJpIj5Kb2U8L2ZvbnQ+PHA+PHA+PGZvbnQgc2l6ZT0zIGZhY2U9IkNhbGlicmkiPmFuZCB0aGUg
Zm9sbG93aW5nIHF1ZXJ5IHJldHVybnMgdGhlIHZhbHVlPC9mb250Pjxmb250IHNpemU9Mz48L2Zv
bnQ+PHA+PGZvbnQgc2l6ZT0zIGZhY2U9IkNhbGlicmkiPnNlbGVjdCBjb3VudCgqKWFzIFJPV0NP
VU5UPC9mb250Pjxmb250IHNpemU9Mz48L2ZvbnQ+PGZvbnQgc2l6ZT0zIGZhY2U9IkNhbGlicmki
PmZyb20gcGVvcGxlOzwvZm9udD48cD48Zm9udCBzaXplPTMgZmFjZT0iQ2FsaWJyaSI+Uk9XQ09V
TlQ8L2ZvbnQ+PHA+PGZvbnQgc2l6ZT0zIGZhY2U9IkNhbGlicmkiPj09PT09PT09PT08L2ZvbnQ+
PHA+PGZvbnQgc2l6ZT0zIGZhY2U9IkNhbGlicmkiPjM8L2ZvbnQ+PHA+PGZvbnQgc2l6ZT0zIGZh
Y2U9IkNhbGlicmkiPjM8L2ZvbnQ+PHA+PGZvbnQgc2l6ZT0zIGZhY2U9IkNhbGlicmkiPldoYXQg
SeKAmW0gbG9va2luZyBmb3IgaXMgdGhlIG91dHB1dCBhczwvZm9udD48cD48Zm9udCBzaXplPTMg
ZmFjZT0iQ2FsaWJyaSI+Uk9XQ09VTlQgLCAmbmJzcDtmaXJzdF9uYW1lPC9mb250PjxwPjxmb250
IHNpemU9MyBmYWNlPSJDYWxpYnJpIj49PT09PT09PT09PT09PT09PT09PT08L2ZvbnQ+PHA+PGZv
bnQgc2l6ZT0zIGZhY2U9IkNhbGlicmkiPjMgLCBNYXJ5PC9mb250PjxwPjxmb250IHNpemU9MyBm
YWNlPSJDYWxpYnJpIj4zICwgU3VlPC9mb250PjxwPjxmb250IHNpemU9MyBmYWNlPSJDYWxpYnJp
Ij4zICwgSm9lPC9mb250PjxwPjxmb250IHNpemU9MyBmYWNlPSJDYWxpYnJpIj5zbyBJIGNhbiB1
c2UgSkRCQyAoc25pcC1pdCkgYXMgZm9sbG93czo8L2ZvbnQ+PHA+PGZvbnQgc2l6ZT0zIGZhY2U9
IkNhbGlicmkiPnJlc3VsdFNldC5nZXRJbnQo4oCcUk9XQ09VTlTigJ0pPC9mb250PjxwPjxmb250
IHNpemU9MyBmYWNlPSJDYWxpYnJpIj5yZXN1bHRTZXQuZ2V0U3RyaW5nKOKAnGZpcnN0X25hbWXi
gJ0pPC9mb250PjxwPjxmb250IHNpemU9MyBmYWNlPSJDYWxpYnJpIj5PbiBhIHNpZGUgbm90ZSw8
L2ZvbnQ+PGZvbnQgc2l6ZT0zPiA8L2ZvbnQ+PGZvbnQgc2l6ZT0zIGZhY2U9IkNhbGlicmkiPk9y
YWNsZQ0KYWxsb3dzIHRoZSBmb2xsb3dpbmc8L2ZvbnQ+PGZvbnQgc2l6ZT0zPiA8L2ZvbnQ+PGZv
bnQgc2l6ZT0zIGZhY2U9IkNhbGlicmkiPnN5bnRheA0KdG8gYWNoaWV2ZSB0aGUgYWJvdmU6PC9m
b250PjxwPjxmb250IHNpemU9MyBmYWNlPSJDYWxpYnJpIj5zZWxlY3QgY291bnQoKikgb3ZlciAo
KTwvZm9udD48Zm9udCBzaXplPTM+PC9mb250Pjxmb250IHNpemU9MyBmYWNlPSJDYWxpYnJpIj5h
cyBST1dDT1VOVDwvZm9udD48Zm9udCBzaXplPTM+IDwvZm9udD48Zm9udCBzaXplPTMgZmFjZT0i
Q2FsaWJyaSI+LA0KZmlyc3RfbmFtZTwvZm9udD48Zm9udCBzaXplPTM+IDwvZm9udD48Zm9udCBz
aXplPTMgZmFjZT0iQ2FsaWJyaSI+ZnJvbQ0KcGVvcGxlPC9mb250PjxwPjxmb250IHNpemU9MyBm
YWNlPSJDYWxpYnJpIj5UaGFua3MsSmltPC9mb250PjxwPjxmb250IGZhY2U9InNhbnMtc2VyaWYi
PjxIVE1MPg0KPEJPRFk+DQo8aW1nIHNyYz0iaHR0cDovL3d3dy5pYnNwbGMuY29tL2ltYWdlcy9l
bWFpbF9mb290ZXJfZmluYWwuZ2lmIj4NCjxmb250IGNvbG9yPSIjOTk5OTk5IiBzaXplPSIxIiBm
YWNlPSJUYWhvbWEiPjxVPg0KRElTQ0xBSU1FUjo8L2ZvbnQ+IDwvVT4NCjxmb250IGNvbG9yPSIj
OTk5OTk5IiBzaXplPSIxIiBmYWNlPSJUYWhvbWEiPg0KIlRoZSBpbmZvcm1hdGlvbiBpbiB0aGlz
IGUtbWFpbCBhbmQgYW55IGF0dGFjaG1lbnQgaXMgaW50ZW5kZWQgb25seSBmb3IgdGhlIHBlcnNv
biB0byB3aG9tIGl0IGlzIGFkZHJlc3NlZCBhbmQgbWF5IGNvbnRhaW4gY29uZmlkZW50aWFsIGFu
ZC9vciBwcml2aWxlZ2VkIG1hdGVyaWFsLiBJZiB5b3UgaGF2ZSByZWNlaXZlZCB0aGlzIGUtbWFp
bCBpbiBlcnJvciwga2luZGx5IGNvbnRhY3QgdGhlIHNlbmRlciBhbmQgZGVzdHJveSBhbGwgY29w
aWVzIG9mIHRoZSBvcmlnaW5hbCBjb21tdW5pY2F0aW9uLiBJQlMgbWFrZXMgbm8gd2FycmFudHks
IGV4cHJlc3Mgb3IgaW1wbGllZCwgbm9yIGd1YXJhbnRlZXMgdGhlIGFjY3VyYWN5LCBhZGVxdWFj
eSBvciBjb21wbGV0ZW5lc3Mgb2YgdGhlIGluZm9ybWF0aW9uIGNvbnRhaW5lZCBpbiB0aGlzIGVt
YWlsIG9yIGFueSBhdHRhY2htZW50IGFuZCBpcyBub3QgbGlhYmxlIGZvciBhbnkgZXJyb3JzLCBk
ZWZlY3RzLCBvbWlzc2lvbnMsIHZpcnVzZXMgb3IgZm9yIHJlc3VsdGFudCBsb3NzIG9yIGRhbWFn
ZSwgaWYgYW55LCBkaXJlY3Qgb3IgaW5kaXJlY3QuIjwvZm9udD48YnI+DQo8Zm9udCBzaXplPTE+
DQo8L2ZvbnQ+DQo8L0JPRFk+DQo8L0hUTUw+PC9mb250Pg0K
--=_alternative 00138CBE652576F2_=--



From Jayadevan.Maymala@ibsplc.com Fri Mar  26 03:42:21 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id A129D63236C;
	Fri, 26 Mar 2010 00:42:21 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024)
	with ESMTP id 48419-08; Fri, 26 Mar 2010 03:42:10 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mx1.ibsplc.com (mx1.ibsplc.com [202.177.44.5])
	by mail.postgresql.org (Postfix) with ESMTP id 5DD9B6321D3;
	Fri, 26 Mar 2010 00:42:09 -0300 (ADT)
X-IronPort-AV: E=Sophos;i="4.51,311,1267381800"; d="scan'208";a="13921711"
Received: from unknown (HELO Green.ibsplc.com) ([192.168.0.4])
	by mx2.ibsplc.com with ESMTP; 26 Mar 2010 08:55:06 +0530
In-Reply-To: <hogm4r$gh6$1@dough.gmane.org>
To: Thomas Kellerer <spam_eater@gmx.net>
Cc: pgsql-sql@postgresql.org,pgsql-sql-owner@postgresql.org
Subject: Re: SQL syntax rowcount value as an extra column in the result set
Message-ID: 
 <OFA0B1E010.BE09B175-ON652576F2.00143421-652576F2.0014316E@LocalDomain>
From: "Jayadevan M" <Jayadevan.Maymala@ibsplc.com>
Date: Fri, 26 Mar 2010 09:12:01 +0530
Content-Type: multipart/alternative;
	boundary="=_alternative 0014316C652576F2_="
References: <594D625E4784AD4EA9D423E292BE6725489FD1@mlbe2k10.cs.myharris.net>
	<hogm4r$gh6$1@dough.gmane.org>
MIME-Version: 1.0
X-KeepSent: A0B1E010:BE09B175-652576F2:00143421; name=$KeepSent; type=4
X-Mailer: Lotus Notes Release 8.5 December 05, 2008
X-Disclaimed: 55951
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.002 tagged_above=-10 required=5
	tests=BAYES_50=0.001, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201003/198
X-Sequence-Number: 33905


--=_alternative 0014316C652576F2_=
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: base64

SGksDQpJIGRvbid0IHRoaW5rIHNvLg0KT3JhY2xlIC0gDQpTUUw+IHNlbGVjdCBjb3VudCgqKSBv
dmVyICgpIGFzIFJPV0NPVU5UICwgZmlyc3RfbmFtZSBmcm9tIHBlb3BsZTsNCg0KICBST1dDT1VO
VCBGSVJTVF9OQU1FDQotLS0tLS0tLS0tIA0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQotLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tDQogICAgICAgICA2IE1hcnkNCiAgICAgICAgIDYgTWFyeQ0KICAgICAg
ICAgNiBKb2huDQogICAgICAgICA2IEpvaG4NCiAgICAgICAgIDYgSm9obg0KICAgICAgICAgNiBK
YWNvYg0KDQo2IHJvd3Mgc2VsZWN0ZWQuDQoNClBvc3RncmVTUUwNCnBvc3RncmVzPSMgc2VsZWN0
IGNvdW50KCopIG92ZXIgKCkgYXMgUk9XQ09VTlQgLCBmaXJzdF9uYW1lIGZyb20gcGVvcGxlOw0K
RVJST1I6ICBzeW50YXggZXJyb3IgYXQgb3IgbmVhciAib3ZlciINCkxJTkUgMTogc2VsZWN0IGNv
dW50KCopIG92ZXIgKCkgYXMgUk9XQ09VTlQgLCBmaXJzdF9uYW1lIGZyb20gcGVvcGxlLi4uDQog
ICAgICAgICAgICAgICAgICAgICAgICBeDQpSZWdhcmRzLA0KSmF5YWRldmFuDQoNCg0KDQpGcm9t
OiAgIFRob21hcyBLZWxsZXJlciA8c3BhbV9lYXRlckBnbXgubmV0Pg0KVG86ICAgICBwZ3NxbC1z
cWxAcG9zdGdyZXNxbC5vcmcNCkRhdGU6ICAgMjYvMDMvMjAxMCAwMzoyNg0KU3ViamVjdDogICAg
ICAgIFJlOiBbU1FMXSBTUUwgc3ludGF4IHJvd2NvdW50IHZhbHVlIGFzIGFuIGV4dHJhIGNvbHVt
biBpbiANCnRoZSByZXN1bHQgc2V0DQpTZW50IGJ5OiAgICAgICAgcGdzcWwtc3FsLW93bmVyQHBv
c3RncmVzcWwub3JnDQoNCg0KDQpTbnlkZXIsIEphbWVzIHdyb3RlIG9uIDI1LjAzLjIwMTAgMjI6
MzM6DQoNCj4gSeKAmW0gdXNpbmcgUG9zdGdyZVNRTCAoOC40LjcwMSkNClRoZXJlIGlzIG5vIHN1
Y2ggdmVyc2lvbi4NClRoZSBjdXJyZW50IHZlcnNpb24gaXMgOC40LjMNCg0KDQo+IE9uIGEgc2lk
ZSBub3RlLCBPcmFjbGUgYWxsb3dzIHRoZSBmb2xsb3dpbmcgc3ludGF4IHRvIGFjaGlldmUgdGhl
IGFib3ZlOg0KPg0KPiBzZWxlY3QgY291bnQoKikgb3ZlciAoKSBhcyBST1dDT1VOVCAsIGZpcnN0
X25hbWUgZnJvbSBwZW9wbGUNCj4NClRoZSBzYW1lIHN5bnRheCB3aWxsIHdvcmsgb24gUG9zdGdy
ZXMNCg0KVGhvbWFzDQoNCg0KLS0gDQpTZW50IHZpYSBwZ3NxbC1zcWwgbWFpbGluZyBsaXN0IChw
Z3NxbC1zcWxAcG9zdGdyZXNxbC5vcmcpDQpUbyBtYWtlIGNoYW5nZXMgdG8geW91ciBzdWJzY3Jp
cHRpb246DQpodHRwOi8vd3d3LnBvc3RncmVzcWwub3JnL21haWxwcmVmL3Bnc3FsLXNxbA0KDQoN
CkRJU0NMQUlNRVI6ICAgIlRoZSBpbmZvcm1hdGlvbiBpbiB0aGlzIGUtbWFpbCBhbmQgYW55IGF0
dGFjaG1lbnQgaXMgaW50ZW5kZWQgb25seSBmb3IgdGhlIHBlcnNvbiB0byB3aG9tIGl0IGlzIGFk
ZHJlc3NlZCBhbmQgbWF5IGNvbnRhaW4gY29uZmlkZW50aWFsIGFuZC9vciBwcml2aWxlZ2VkIG1h
dGVyaWFsLiBJZiB5b3UgaGF2ZSByZWNlaXZlZCB0aGlzIGUtbWFpbCBpbiBlcnJvciwga2luZGx5
IGNvbnRhY3QgdGhlIHNlbmRlciBhbmQgZGVzdHJveSBhbGwgY29waWVzIG9mIHRoZSBvcmlnaW5h
bCBjb21tdW5pY2F0aW9uLiBJQlMgbWFrZXMgbm8gd2FycmFudHksIGV4cHJlc3Mgb3IgaW1wbGll
ZCwgbm9yIGd1YXJhbnRlZXMgdGhlIGFjY3VyYWN5LCBhZGVxdWFjeSBvciBjb21wbGV0ZW5lc3Mg
b2YgdGhlIGluZm9ybWF0aW9uIGNvbnRhaW5lZCBpbiB0aGlzIGVtYWlsIG9yIGFueSBhdHRhY2ht
ZW50IGFuZCBpcyBub3QgbGlhYmxlIGZvciBhbnkgZXJyb3JzLCBkZWZlY3RzLCBvbWlzc2lvbnMs
IHZpcnVzZXMgb3IgZm9yIHJlc3VsdGFudCBsb3NzIG9yIGRhbWFnZSwgaWYgYW55LCBkaXJlY3Qg
b3IgaW5kaXJlY3QuIiA=

--=_alternative 0014316C652576F2_=
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: base64

PGZvbnQgc2l6ZT0yIGZhY2U9InNhbnMtc2VyaWYiPkhpLDwvZm9udD48YnI+PGZvbnQgc2l6ZT0y
IGZhY2U9InNhbnMtc2VyaWYiPkkgZG9uJ3QgdGhpbmsgc28uPC9mb250Pjxicj48Zm9udCBzaXpl
PTIgZmFjZT0ic2Fucy1zZXJpZiI+T3JhY2xlIC0gPC9mb250Pjxicj48Zm9udCBzaXplPTIgZmFj
ZT0ic2Fucy1zZXJpZiI+U1FMJmd0OyBzZWxlY3QgY291bnQoKikgb3ZlciAoKSBhcyBST1dDT1VO
VA0KLCBmaXJzdF9uYW1lIGZyb20gcGVvcGxlOzwvZm9udD48YnI+PGJyPjxmb250IHNpemU9MiBm
YWNlPSJzYW5zLXNlcmlmIj4mbmJzcDsgUk9XQ09VTlQgRklSU1RfTkFNRTwvZm9udD48YnI+PGZv
bnQgc2l6ZT0yIGZhY2U9InNhbnMtc2VyaWYiPi0tLS0tLS0tLS0gLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tPC9mb250
Pjxicj48Zm9udCBzaXplPTIgZmFjZT0ic2Fucy1zZXJpZiI+LS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLTwvZm9udD48YnI+PGZvbnQgc2l6ZT0yIGZhY2U9InNhbnMtc2VyaWYiPiZuYnNw
OyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDs2DQpNYXJ5PC9mb250Pjxicj48Zm9udCBzaXpl
PTIgZmFjZT0ic2Fucy1zZXJpZiI+Jm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOzYN
Ck1hcnk8L2ZvbnQ+PGJyPjxmb250IHNpemU9MiBmYWNlPSJzYW5zLXNlcmlmIj4mbmJzcDsgJm5i
c3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7Ng0KSm9objwvZm9udD48YnI+PGZvbnQgc2l6ZT0yIGZh
Y2U9InNhbnMtc2VyaWYiPiZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDs2DQpKb2hu
PC9mb250Pjxicj48Zm9udCBzaXplPTIgZmFjZT0ic2Fucy1zZXJpZiI+Jm5ic3A7ICZuYnNwOyAm
bmJzcDsgJm5ic3A7ICZuYnNwOzYNCkpvaG48L2ZvbnQ+PGJyPjxmb250IHNpemU9MiBmYWNlPSJz
YW5zLXNlcmlmIj4mbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7Ng0KSmFjb2I8L2Zv
bnQ+PGJyPjxicj48Zm9udCBzaXplPTIgZmFjZT0ic2Fucy1zZXJpZiI+NiByb3dzIHNlbGVjdGVk
LjwvZm9udD48YnI+PGJyPjxmb250IHNpemU9MiBmYWNlPSJzYW5zLXNlcmlmIj5Qb3N0Z3JlU1FM
PC9mb250Pjxicj48Zm9udCBzaXplPTIgZmFjZT0ic2Fucy1zZXJpZiI+cG9zdGdyZXM9IyBzZWxl
Y3QgY291bnQoKikgb3ZlciAoKSBhcw0KUk9XQ09VTlQgLCBmaXJzdF9uYW1lIGZyb20gcGVvcGxl
OzwvZm9udD48YnI+PGZvbnQgc2l6ZT0yIGZhY2U9InNhbnMtc2VyaWYiPkVSUk9SOiAmbmJzcDtz
eW50YXggZXJyb3IgYXQgb3IgbmVhcg0KJnF1b3Q7b3ZlciZxdW90OzwvZm9udD48YnI+PGZvbnQg
c2l6ZT0yIGZhY2U9InNhbnMtc2VyaWYiPkxJTkUgMTogc2VsZWN0IGNvdW50KCopIG92ZXIgKCkg
YXMgUk9XQ09VTlQNCiwgZmlyc3RfbmFtZSBmcm9tIHBlb3BsZS4uLjwvZm9udD48YnI+PGZvbnQg
c2l6ZT0yIGZhY2U9InNhbnMtc2VyaWYiPiZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJz
cDsgJm5ic3A7DQombmJzcDsgJm5ic3A7ICZuYnNwOyAmbmJzcDsgJm5ic3A7ICZuYnNwOyBePC9m
b250Pjxicj48Zm9udCBzaXplPTIgZmFjZT0ic2Fucy1zZXJpZiI+UmVnYXJkcyw8L2ZvbnQ+PGJy
Pjxmb250IHNpemU9MiBmYWNlPSJUcmVidWNoZXQgTVMiPkpheWFkZXZhbjwvZm9udD48YnI+PGJy
Pjxicj48YnI+PGZvbnQgc2l6ZT0xIGNvbG9yPSM1ZjVmNWYgZmFjZT0ic2Fucy1zZXJpZiI+RnJv
bTogJm5ic3A7ICZuYnNwOyAmbmJzcDsNCiZuYnNwOzwvZm9udD48Zm9udCBzaXplPTEgZmFjZT0i
c2Fucy1zZXJpZiI+VGhvbWFzIEtlbGxlcmVyICZsdDtzcGFtX2VhdGVyQGdteC5uZXQmZ3Q7PC9m
b250Pjxicj48Zm9udCBzaXplPTEgY29sb3I9IzVmNWY1ZiBmYWNlPSJzYW5zLXNlcmlmIj5Ubzog
Jm5ic3A7ICZuYnNwOyAmbmJzcDsNCiZuYnNwOzwvZm9udD48Zm9udCBzaXplPTEgZmFjZT0ic2Fu
cy1zZXJpZiI+cGdzcWwtc3FsQHBvc3RncmVzcWwub3JnPC9mb250Pjxicj48Zm9udCBzaXplPTEg
Y29sb3I9IzVmNWY1ZiBmYWNlPSJzYW5zLXNlcmlmIj5EYXRlOiAmbmJzcDsgJm5ic3A7ICZuYnNw
Ow0KJm5ic3A7PC9mb250Pjxmb250IHNpemU9MSBmYWNlPSJzYW5zLXNlcmlmIj4yNi8wMy8yMDEw
IDAzOjI2PC9mb250Pjxicj48Zm9udCBzaXplPTEgY29sb3I9IzVmNWY1ZiBmYWNlPSJzYW5zLXNl
cmlmIj5TdWJqZWN0OiAmbmJzcDsgJm5ic3A7DQombmJzcDsgJm5ic3A7PC9mb250Pjxmb250IHNp
emU9MSBmYWNlPSJzYW5zLXNlcmlmIj5SZTogW1NRTF0gU1FMDQpzeW50YXggcm93Y291bnQgdmFs
dWUgYXMgYW4gZXh0cmEgY29sdW1uIGluIHRoZSByZXN1bHQgc2V0PC9mb250Pjxicj48Zm9udCBz
aXplPTEgY29sb3I9IzVmNWY1ZiBmYWNlPSJzYW5zLXNlcmlmIj5TZW50IGJ5OiAmbmJzcDsgJm5i
c3A7DQombmJzcDsgJm5ic3A7PC9mb250Pjxmb250IHNpemU9MSBmYWNlPSJzYW5zLXNlcmlmIj5w
Z3NxbC1zcWwtb3duZXJAcG9zdGdyZXNxbC5vcmc8L2ZvbnQ+PGJyPjxociBub3NoYWRlPjxicj48
YnI+PGJyPjx0dD48Zm9udCBzaXplPTI+U255ZGVyLCBKYW1lcyB3cm90ZSBvbiAyNS4wMy4yMDEw
IDIyOjMzOjxicj48YnI+Jmd0OyBJ4oCZbSB1c2luZyBQb3N0Z3JlU1FMICg4LjQuNzAxKTxicj5U
aGVyZSBpcyBubyBzdWNoIHZlcnNpb24uPGJyPlRoZSBjdXJyZW50IHZlcnNpb24gaXMgOC40LjM8
YnI+PGJyPjxicj4mZ3Q7IE9uIGEgc2lkZSBub3RlLCBPcmFjbGUgYWxsb3dzIHRoZSBmb2xsb3dp
bmcgc3ludGF4IHRvIGFjaGlldmUgdGhlDQphYm92ZTo8YnI+Jmd0Ozxicj4mZ3Q7IHNlbGVjdCBj
b3VudCgqKSBvdmVyICgpIGFzIFJPV0NPVU5UICwgZmlyc3RfbmFtZSBmcm9tIHBlb3BsZTxicj4m
Z3Q7PGJyPlRoZSBzYW1lIHN5bnRheCB3aWxsIHdvcmsgb24gUG9zdGdyZXM8YnI+PGJyPlRob21h
czxicj48YnI+PGJyPi0tIDxicj5TZW50IHZpYSBwZ3NxbC1zcWwgbWFpbGluZyBsaXN0IChwZ3Nx
bC1zcWxAcG9zdGdyZXNxbC5vcmcpPGJyPlRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNjcmlw
dGlvbjo8YnI+PC9mb250PjwvdHQ+PGEgaHJlZj0iaHR0cDovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9t
YWlscHJlZi9wZ3NxbC1zcWwiPjx0dD48Zm9udCBzaXplPTI+aHR0cDovL3d3dy5wb3N0Z3Jlc3Fs
Lm9yZy9tYWlscHJlZi9wZ3NxbC1zcWw8L2ZvbnQ+PC90dD48L2E+PHR0Pjxmb250IHNpemU9Mj48
YnI+PC9mb250PjwvdHQ+PGJyPjxmb250IGZhY2U9InNhbnMtc2VyaWYiPjxIVE1MPg0KPEJPRFk+
DQo8aW1nIHNyYz0iaHR0cDovL3d3dy5pYnNwbGMuY29tL2ltYWdlcy9lbWFpbF9mb290ZXJfZmlu
YWwuZ2lmIj4NCjxmb250IGNvbG9yPSIjOTk5OTk5IiBzaXplPSIxIiBmYWNlPSJUYWhvbWEiPjxV
Pg0KRElTQ0xBSU1FUjo8L2ZvbnQ+IDwvVT4NCjxmb250IGNvbG9yPSIjOTk5OTk5IiBzaXplPSIx
IiBmYWNlPSJUYWhvbWEiPg0KIlRoZSBpbmZvcm1hdGlvbiBpbiB0aGlzIGUtbWFpbCBhbmQgYW55
IGF0dGFjaG1lbnQgaXMgaW50ZW5kZWQgb25seSBmb3IgdGhlIHBlcnNvbiB0byB3aG9tIGl0IGlz
IGFkZHJlc3NlZCBhbmQgbWF5IGNvbnRhaW4gY29uZmlkZW50aWFsIGFuZC9vciBwcml2aWxlZ2Vk
IG1hdGVyaWFsLiBJZiB5b3UgaGF2ZSByZWNlaXZlZCB0aGlzIGUtbWFpbCBpbiBlcnJvciwga2lu
ZGx5IGNvbnRhY3QgdGhlIHNlbmRlciBhbmQgZGVzdHJveSBhbGwgY29waWVzIG9mIHRoZSBvcmln
aW5hbCBjb21tdW5pY2F0aW9uLiBJQlMgbWFrZXMgbm8gd2FycmFudHksIGV4cHJlc3Mgb3IgaW1w
bGllZCwgbm9yIGd1YXJhbnRlZXMgdGhlIGFjY3VyYWN5LCBhZGVxdWFjeSBvciBjb21wbGV0ZW5l
c3Mgb2YgdGhlIGluZm9ybWF0aW9uIGNvbnRhaW5lZCBpbiB0aGlzIGVtYWlsIG9yIGFueSBhdHRh
Y2htZW50IGFuZCBpcyBub3QgbGlhYmxlIGZvciBhbnkgZXJyb3JzLCBkZWZlY3RzLCBvbWlzc2lv
bnMsIHZpcnVzZXMgb3IgZm9yIHJlc3VsdGFudCBsb3NzIG9yIGRhbWFnZSwgaWYgYW55LCBkaXJl
Y3Qgb3IgaW5kaXJlY3QuIjwvZm9udD48YnI+DQo8Zm9udCBzaXplPTE+DQo8L2ZvbnQ+DQo8L0JP
RFk+DQo8L0hUTUw+PC9mb250Pg0K
--=_alternative 0014316C652576F2_=--



From andreas.kretschmer@schollglas.com Fri Mar  26 06:24:04 2010
Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 8069C632386
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 26 Mar 2010 03:24:04 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 56702-04 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 26 Mar 2010 06:23:50 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.10])
	by mail.postgresql.org (Postfix) with ESMTP id E347063161C
	for <pgsql-sql@postgresql.org>; Fri, 26 Mar 2010 03:23:52 -0300 (ADT)
Received: from webserv.wug.de ([194.25.154.138])
	by mrelayeu.kundenserver.de (node=mreu1) with ESMTP (Nemesis)
	id 0M7o3Q-1Nhtkk3mD2-00vCvP; Fri, 26 Mar 2010 07:23:51 +0100
Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1)
	id 1Nv2xS-0001uN-00
	for pgsql-sql@postgresql.org; Fri, 26 Mar 2010 07:23:50 +0100
Date: Fri, 26 Mar 2010 07:23:50 +0100
From: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
To: pgsql-sql@postgresql.org
Subject: Re: SQL syntax rowcount value as an extra column in the result set
Message-ID: <20100326062350.GA6817@a-kretschmer.de>
References: <594D625E4784AD4EA9D423E292BE6725489FD1@mlbe2k10.cs.myharris.net>
	<hogm4r$gh6$1@dough.gmane.org>
	<OFA0B1E010.BE09B175-ON652576F2.00143421-652576F2.0014316E@LocalDomain>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <OFA0B1E010.BE09B175-ON652576F2.00143421-652576F2.0014316E@LocalDomain>
X-OS: Debian/GNU Linux - weil ich es mir Wert bin!
User-Agent: Mutt/1.5.9i
X-Provags-ID: V01U2FsdGVkX1+k/LXgjgOl4vyIHcJysRdCc+NvJ+6bsdJyAV7
	nGSMqloOZB3jrv4/yew0R/+9hM16264KTzPG5M9UPLF9/m3ovv
	h43eZmfdwLLI/1bOJYwVA==
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.966 tagged_above=-10 required=5 tests=AWL=0.633,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201003/199
X-Sequence-Number: 33906

In response to Jayadevan M :
> Hi,
> I don't think so.
> Oracle -
> SQL> select count(*) over () as ROWCOUNT , first_name from people;
> 
>   ROWCOUNT FIRST_NAME
> ----------
> ---------------------------------------------------------------------
> -------------------------------
>          6 Mary
>          6 Mary
>          6 John
>          6 John
>          6 John
>          6 Jacob
> 
> 6 rows selected.
> 
> PostgreSQL
> postgres=# select count(*) over () as ROWCOUNT , first_name from people;
> ERROR:  syntax error at or near "over"
> LINE 1: select count(*) over () as ROWCOUNT , first_name from people...

It works, but you should use a recent version:

test=*# select count(1) over (), i from foo;
 count | i
-------+----
     8 |  1
     8 |  2
     8 |  3
     8 |  6
     8 |  7
     8 |  9
     8 | 13
     8 | 14
(8 rows)

test=*# select version();
                                                version
--------------------------------------------------------------------------------------------------------
 PostgreSQL 8.4.2 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.3.real
(Debian 4.3.2-1.1) 4.3.2, 64-bit
(1 row)

test=*#

Regards, Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99



From Jayadevan.Maymala@ibsplc.com Fri Mar  26 06:55:47 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 5D33A6324A6;
	Fri, 26 Mar 2010 03:55:47 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024)
	with ESMTP id 78254-03; Fri, 26 Mar 2010 06:55:36 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mx1.ibsplc.com (mx1.ibsplc.com [202.177.44.5])
	by mail.postgresql.org (Postfix) with ESMTP id 1F9D06323CE;
	Fri, 26 Mar 2010 03:55:34 -0300 (ADT)
X-IronPort-AV: E=Sophos;i="4.51,312,1267381800"; d="scan'208";a="13927559"
Received: from unknown (HELO Green.ibsplc.com) ([192.168.0.4])
	by mx2.ibsplc.com with ESMTP; 26 Mar 2010 12:08:30 +0530
In-Reply-To: <20100326062350.GA6817@a-kretschmer.de>
To: "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Cc: pgsql-sql@postgresql.org,pgsql-sql-owner@postgresql.org
Subject: Re: SQL syntax rowcount value as an extra column in the result set
Message-ID: 
 <OF3566EE01.958C8348-ON652576F2.002579A1-652576F2.002608F3@LocalDomain>
From: "Jayadevan M" <Jayadevan.Maymala@ibsplc.com>
Date: Fri, 26 Mar 2010 12:26:54 +0530
Content-Type: multipart/alternative;
	boundary="=_alternative 002608F2652576F2_="
References: <594D625E4784AD4EA9D423E292BE6725489FD1@mlbe2k10.cs.myharris.net>
	<hogm4r$gh6$1@dough.gmane.org>
	<OFA0B1E010.BE09B175-ON652576F2.00143421-652576F2.0014316E@LocalDomain>
	<20100326062350.GA6817@a-kretschmer.de>
MIME-Version: 1.0
X-KeepSent: 3566EE01:958C8348-652576F2:002579A1; name=$KeepSent; type=4
X-Mailer: Lotus Notes Release 8.5 December 05, 2008
X-Disclaimed: 58411
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.002 tagged_above=-10 required=5
	tests=BAYES_50=0.001, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201003/201
X-Sequence-Number: 33908


--=_alternative 002608F2652576F2_=
Content-Type: text/plain; charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

Hi,
>It works, but you should use a recent version:

>test=3D*# select count(1) over (), i from foo;
> count | i
>-------+----
>     8 |  1
>     8 |  2
>     8 |  3
>     8 |  6
>     8 |  7
>     8 |  9
>     8 | 13
>     8 | 14
>(8 rows)

> test=3D*# select version();
>                                                version
>=20
---------------------------------------------------------------------------=
-----------------------------
>  PostgreSQL 8.4.2 on x86=5F64-pc-linux-gnu, compiled by GCC gcc-4.3.real
> (Debian 4.3.2-1.1) 4.3.2, 64-bit
> (1 row)

Thank you for setting that right. Apologies for not checking version.
Is this approach better compared to=20
postgres=3D# select * from (select count(*) from people ) p, (select=20
firstname from people)p2;
 count | firstname
-------+-----------
     5 | Mary
     5 | Mary
     5 | John
     5 | John
     5 | Jacob
(5 rows)
This gives me
postgres=3D# explain  select * from (select count(*) from people )as p,=20
(select firstname from people)p2;
                             QUERY PLAN
---------------------------------------------------------------------
 Nested Loop  (cost=3D14.00..30.42 rows=3D320 width=3D226)
   ->  Aggregate  (cost=3D14.00..14.01 rows=3D1 width=3D0)
         ->  Seq Scan on people  (cost=3D0.00..13.20 rows=3D320 width=3D0)
   ->  Seq Scan on people  (cost=3D0.00..13.20 rows=3D320 width=3D218)

Since I don't have 8.4, I am not in a position to do explain on that=20
version. My guess - over () will be better. My query does sequential=20
scans/nested loop...(if there are no indexes)

Regards,
Regards,
Jayadevan
DISCLAIMER:   "The information in this e-mail and any attachment is intende=
d only for the person to whom it is addressed and may contain confidential =
and/or privileged material. If you have received this e-mail in error, kind=
ly contact the sender and destroy all copies of the original communication.=
 IBS makes no warranty, express or implied, nor guarantees the accuracy, ad=
equacy or completeness of the information contained in this email or any at=
tachment and is not liable for any errors, defects, omissions, viruses or f=
or resultant loss or damage, if any, direct or indirect." =

--=_alternative 002608F2652576F2_=
Content-Type: text/html; charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

<tt><font size=3D2>Hi,</font></tt><br><tt><font size=3D2>&gt;It works, but =
you should use a recent version:<br><br>&gt;test=3D*# select count(1) over =
(), i from foo;<br>&gt; count | i<br>&gt;-------+----<br>&gt; &nbsp; &nbsp;=
 8 | &nbsp;1<br>&gt; &nbsp; &nbsp; 8 | &nbsp;2<br>&gt; &nbsp; &nbsp; 8 | &n=
bsp;3<br>&gt; &nbsp; &nbsp; 8 | &nbsp;6<br>&gt; &nbsp; &nbsp; 8 | &nbsp;7<b=
r>&gt; &nbsp; &nbsp; 8 | &nbsp;9<br>&gt; &nbsp; &nbsp; 8 | 13<br>&gt; &nbsp=
; &nbsp; 8 | 14<br>&gt;(8 rows)<br><br>&gt; test=3D*# select version();<br>=
&gt; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nbsp; &nbsp; &nbsp;version<br>&gt; ---------------------------------------=
-----------------------------------------------------------------<br>&gt; &=
nbsp;PostgreSQL 8.4.2 on x86=5F64-pc-linux-gnu, compiled by GCC gcc-4.3.rea=
l<br>&gt; (Debian 4.3.2-1.1) 4.3.2, 64-bit<br>&gt; (1 row)<br></font></tt><=
br><font size=3D2 face=3D"sans-serif">Thank you for setting that right. Apo=
logies
for not checking version.</font><br><font size=3D2 face=3D"sans-serif">Is t=
his approach better compared to
</font><br><font size=3D2 face=3D"sans-serif">postgres=3D# select * from (s=
elect count(*)
from people ) p, (select firstname from people)p2;</font><br><font size=3D2=
 face=3D"sans-serif">&nbsp;count | firstname</font><br><font size=3D2 face=
=3D"sans-serif">-------+-----------</font><br><font size=3D2 face=3D"sans-s=
erif">&nbsp; &nbsp; &nbsp;5 | Mary</font><br><font size=3D2 face=3D"sans-se=
rif">&nbsp; &nbsp; &nbsp;5 | Mary</font><br><font size=3D2 face=3D"sans-ser=
if">&nbsp; &nbsp; &nbsp;5 | John</font><br><font size=3D2 face=3D"sans-seri=
f">&nbsp; &nbsp; &nbsp;5 | John</font><br><font size=3D2 face=3D"sans-serif=
">&nbsp; &nbsp; &nbsp;5 | Jacob</font><br><font size=3D2 face=3D"sans-serif=
">(5 rows)</font><br><font size=3D2 face=3D"sans-serif">This gives me</font=
><br><font size=3D2 face=3D"sans-serif">postgres=3D# explain &nbsp;select *=
 from
(select count(*) from people )as p, (select firstname from people)p2;</font=
><br><font size=3D2 face=3D"sans-serif">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =
&nbsp;
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;QUERY PLAN</f=
ont><br><font size=3D2 face=3D"sans-serif">--------------------------------=
-------------------------------------</font><br><font size=3D2 face=3D"sans=
-serif">&nbsp;Nested Loop &nbsp;(cost=3D14.00..30.42
rows=3D320 width=3D226)</font><br><font size=3D2 face=3D"sans-serif">&nbsp;=
 &nbsp;-&gt; &nbsp;Aggregate &nbsp;(cost=3D14.00..14.01
rows=3D1 width=3D0)</font><br><font size=3D2 face=3D"sans-serif">&nbsp; &nb=
sp; &nbsp; &nbsp; &nbsp;-&gt;
&nbsp;Seq Scan on people &nbsp;(cost=3D0.00..13.20 rows=3D320 width=3D0)</f=
ont><br><font size=3D2 face=3D"sans-serif">&nbsp; &nbsp;-&gt; &nbsp;Seq Sca=
n on
people &nbsp;(cost=3D0.00..13.20 rows=3D320 width=3D218)</font><br><br><fon=
t size=3D2 face=3D"sans-serif">Since I don't have 8.4, I am not in
a position to do explain on that version. My guess - over () will be better.
My query does sequential scans/nested loop...(if there are no indexes)</fon=
t><br><br><font size=3D2 face=3D"sans-serif">Regards,</font><br><font size=
=3D2 face=3D"sans-serif">Regards,</font><br><font size=3D2 face=3D"Trebuche=
t MS">Jayadevan</font><font face=3D"sans-serif"><HTML>
<BODY>
<img src=3D"http://www.ibsplc.com/images/email=5Ffooter=5Ffinal.gif">
<font color=3D"#999999" size=3D"1" face=3D"Tahoma"><U>
DISCLAIMER:</font> </U>
<font color=3D"#999999" size=3D"1" face=3D"Tahoma">
"The information in this e-mail and any attachment is intended only for the=
 person to whom it is addressed and may contain confidential and/or privile=
ged material. If you have received this e-mail in error, kindly contact the=
 sender and destroy all copies of the original communication. IBS makes no =
warranty, express or implied, nor guarantees the accuracy, adequacy or comp=
leteness of the information contained in this email or any attachment and i=
s not liable for any errors, defects, omissions, viruses or for resultant l=
oss or damage, if any, direct or indirect."</font><br>
<font size=3D1>
</font>
</BODY>
</HTML></font>
--=_alternative 002608F2652576F2_=--



From spam_eater@gmx.net Fri Mar  26 07:15:22 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id E9B846324A6
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 26 Mar 2010 04:15:22 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 81947-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 26 Mar 2010 07:15:11 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from lo.gmane.org (lo.gmane.org [80.91.229.12])
	by mail.postgresql.org (Postfix) with ESMTP id 867756323CE
	for <pgsql-sql@postgresql.org>; Fri, 26 Mar 2010 04:15:11 -0300 (ADT)
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1Nv3l5-0005nE-9C
	for pgsql-sql@postgresql.org; Fri, 26 Mar 2010 08:15:07 +0100
Received: from 217.110.94.67 ([217.110.94.67])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Fri, 26 Mar 2010 08:15:07 +0100
Received: from spam_eater by 217.110.94.67 with local (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Fri, 26 Mar 2010 08:15:07 +0100
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-sql@postgresql.org
From: Thomas Kellerer <spam_eater@gmx.net>
Subject: Re: SQL syntax rowcount value as an extra column in the result set
Date: Fri, 26 Mar 2010 08:14:50 +0100
Lines: 6
Message-ID: <hohmta$53e$1@dough.gmane.org>
References: <594D625E4784AD4EA9D423E292BE6725489FD1@mlbe2k10.cs.myharris.net>
	<hogm4r$gh6$1@dough.gmane.org>
	<OFA0B1E010.BE09B175-ON652576F2.00143421-652576F2.0014316E@LocalDomain>
	<20100326062350.GA6817@a-kretschmer.de>
	<OF3566EE01.958C8348-ON652576F2.002579A1-652576F2.002608F3@LocalDomain>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@dough.gmane.org
X-Gmane-NNTP-Posting-Host: 217.110.94.67
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666
In-Reply-To: 
 <OF3566EE01.958C8348-ON652576F2.002579A1-652576F2.002608F3@LocalDomain>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.068 tagged_above=-10 required=5
	tests=BAYES_50=0.001, RCVD_NUMERIC_HELO=2.067
X-Spam-Level: **
X-Archive-Number: 201003/202
X-Sequence-Number: 33909

Jayadevan M, 26.03.2010 07:56:
> Thank you for setting that right. Apologies for not checking version.

The orginal poster stated that he is using 8.4, so that solution will work for him.

Thomas




From jsnyde07@harris.com Mon Mar  29 16:26:02 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id BF740633515
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 29 Mar 2010 13:26:02 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 79595-02-6 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 29 Mar 2010 16:25:52 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mlbe2k1.cs.myharris.net (mlbe2k1.cs.myharris.net
	[137.237.90.88])
	by mail.postgresql.org (Postfix) with ESMTP id 5878F6331E6
	for <pgsql-sql@postgresql.org>; Mon, 29 Mar 2010 13:25:52 -0300 (ADT)
Received: from mail pickup service by mlbe2k1.cs.myharris.net with Microsoft
	SMTPSVC; Mon, 29 Mar 2010 12:25:49 -0400
Received: from mlbe2k10.cs.myharris.net ([137.237.89.92]) by
	mlbe2k1.cs.myharris.net with Microsoft SMTPSVC(6.0.3790.3959);
	Mon, 29 Mar 2010 12:25:48 -0400
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="utf-8"
Content-Transfer-Encoding: base64
Subject: Re: SQL syntax rowcount value as an extra column in the result set
Date: Mon, 29 Mar 2010 12:25:48 -0400
Message-ID: <594D625E4784AD4EA9D423E292BE6725E07CA0@mlbe2k10.cs.myharris.net>
In-Reply-To: <hohmta$53e$1@dough.gmane.org>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: [SQL] SQL syntax rowcount value as an extra column in the result
	set
Thread-Index: AcrMtCFx5pwi3KFsTXS1yL9j9TpiGQCp/WBg
References: <594D625E4784AD4EA9D423E292BE6725489FD1@mlbe2k10.cs.myharris.net>
	<hogm4r$gh6$1@dough.gmane.org>
	<OFA0B1E010.BE09B175-ON652576F2.00143421-652576F2.0014316E@LocalDomain>
	<20100326062350.GA6817@a-kretschmer.de>
	<OF3566EE01.958C8348-ON652576F2.002579A1-652576F2.002608F3@LocalDomain>
	<hohmta$53e$1@dough.gmane.org>
From: "Snyder, James" <jsnyde07@harris.com>
To: <pgsql-sql@postgresql.org>
X-OriginalArrivalTime: 29 Mar 2010 16:25:48.0496 (UTC)
	FILETIME=[7D9E7D00:01CACF5C]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201003/210
X-Sequence-Number: 33917

VGhhbmtzIGZvciBhbGwgdGhlIGRpYWxvZyBvbiB0aGlzIHN1YmplY3QuDQoNCk15ICJ2ZXJzaW9u
IiB3YXMgZGVyaXZlZCBmcm9tIHRoZSBwb3N0Z3JlU1FMJ3MgLmphciBmaWxlIChzcGVjaWZpY2Fs
bHkgbmFtZWQgInBvc3RncmVzcWwtOC40LTcwMS5qZGJjNC5qYXIiKSB0aGF0IEknbSB1c2luZy4g
V2hlbiBJIGRvIHRoZSBmb2xsb3dpbmc6DQoNCnNlbGVjdCB2ZXJzaW9uKCkNCg0KSSBnZXQgdGhl
IGZvbGxvd2luZzoNCg0KUG9zdGdyZVNRTCA4LjMuNg0KDQpJJ20gZ29pbmcgdG8gY2hlY2sgdGhp
cyBvdXQuDQoNClRoYW5rcy4uLkppbQ0KDQoNCi0tLS0tT3JpZ2luYWwgTWVzc2FnZS0tLS0tDQpG
cm9tOiBwZ3NxbC1zcWwtb3duZXJAcG9zdGdyZXNxbC5vcmcgW21haWx0bzpwZ3NxbC1zcWwtb3du
ZXJAcG9zdGdyZXNxbC5vcmddIE9uIEJlaGFsZiBPZiBUaG9tYXMgS2VsbGVyZXINClNlbnQ6IEZy
aWRheSwgTWFyY2ggMjYsIDIwMTAgMzoxNSBBTQ0KVG86IHBnc3FsLXNxbEBwb3N0Z3Jlc3FsLm9y
Zw0KU3ViamVjdDogUmU6IFtTUUxdIFNRTCBzeW50YXggcm93Y291bnQgdmFsdWUgYXMgYW4gZXh0
cmEgY29sdW1uIGluIHRoZSByZXN1bHQgc2V0DQoNCg0KSmF5YWRldmFuIE0sIDI2LjAzLjIwMTAg
MDc6NTY6DQo+IFRoYW5rIHlvdSBmb3Igc2V0dGluZyB0aGF0IHJpZ2h0LiBBcG9sb2dpZXMgZm9y
IG5vdCBjaGVja2luZyB2ZXJzaW9uLg0KDQpUaGUgb3JnaW5hbCBwb3N0ZXIgc3RhdGVkIHRoYXQg
aGUgaXMgdXNpbmcgOC40LCBzbyB0aGF0IHNvbHV0aW9uIHdpbGwgd29yayBmb3IgaGltLg0KDQpU
aG9tYXMNCg0KDQotLSANClNlbnQgdmlhIHBnc3FsLXNxbCBtYWlsaW5nIGxpc3QgKHBnc3FsLXNx
bEBwb3N0Z3Jlc3FsLm9yZykNClRvIG1ha2UgY2hhbmdlcyB0byB5b3VyIHN1YnNjcmlwdGlvbjoN
Cmh0dHA6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWFpbHByZWYvcGdzcWwtc3FsDQo=



From spam_eater@gmx.net Tue Mar  30 08:06:17 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id ED50A6329B6
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 30 Mar 2010 05:06:17 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 40552-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue, 30 Mar 2010 08:06:06 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from lo.gmane.org (lo.gmane.org [80.91.229.12])
	by mail.postgresql.org (Postfix) with ESMTP id D6F4363293E
	for <pgsql-sql@postgresql.org>; Tue, 30 Mar 2010 05:03:47 -0300 (ADT)
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <sql-pgsql-sql@m.gmane.org>) id 1NwWQL-0007tb-1f
	for pgsql-sql@postgresql.org; Tue, 30 Mar 2010 10:03:45 +0200
Received: from 217.110.94.67 ([217.110.94.67])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Tue, 30 Mar 2010 10:03:45 +0200
Received: from spam_eater by 217.110.94.67 with local (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <pgsql-sql@postgresql.org>; Tue, 30 Mar 2010 10:03:45 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: pgsql-sql@postgresql.org
From: Thomas Kellerer <spam_eater@gmx.net>
Subject: Re: SQL syntax rowcount value as an extra column in the result set
Date: Tue, 30 Mar 2010 10:03:35 +0200
Lines: 15
Message-ID: <hosb8m$c6c$1@dough.gmane.org>
References: <594D625E4784AD4EA9D423E292BE6725489FD1@mlbe2k10.cs.myharris.net>
	<hogm4r$gh6$1@dough.gmane.org>
	<OFA0B1E010.BE09B175-ON652576F2.00143421-652576F2.0014316E@LocalDomain>
	<20100326062350.GA6817@a-kretschmer.de>
	<OF3566EE01.958C8348-ON652576F2.002579A1-652576F2.002608F3@LocalDomain>
	<hohmta$53e$1@dough.gmane.org>
	<594D625E4784AD4EA9D423E292BE6725E07CA0@mlbe2k10.cs.myharris.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@dough.gmane.org
X-Gmane-NNTP-Posting-Host: 217.110.94.67
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666
In-Reply-To: <594D625E4784AD4EA9D423E292BE6725E07CA0@mlbe2k10.cs.myharris.net>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.068 tagged_above=-10 required=5
	tests=BAYES_50=0.001, RCVD_NUMERIC_HELO=2.067
X-Spam-Level: **
X-Archive-Number: 201003/214
X-Sequence-Number: 33921

Snyder, James, 29.03.2010 18:25:
> Thanks for all the dialog on this subject.
>
> My "version" was derived from the postgreSQL's .jar file (specifically named "postgresql-8.4-701.jdbc4.jar") that I'm using. When I do the following:
>
> select version()
>
> I get the following:
>
> PostgreSQL 8.3.6
>

Then you cannot use the new windowing functions, you will need to upgrade to 8.4

Thomas