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

From: "Snyder, James" <jsnyde07(at)harris(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: SQL syntax rowcount value as an extra column in the result set
Date: 2010-03-29 16:25:48
Message-ID: 594D625E4784AD4EA9D423E292BE6725E07CA0@mlbe2k10.cs.myharris.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

I'm going to check this out.

Thanks...Jim

-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org [mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Thomas Kellerer
Sent: Friday, March 26, 2010 3:15 AM
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] SQL syntax rowcount value as an extra column in the result set

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

--
Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Snyder, James 2010-03-29 16:33:42 SQL Developer accessing PostgreSQL
Previous Message Jorge Godoy 2010-03-28 01:51:52 Re: Week to date function