Skip site navigation (1) Skip section navigation (2)

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-30 08:03:35
Message-ID: hosb8m$c6c$1@dough.gmane.org (view raw or flat)
Thread:
Lists: pgsql-sql
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


In response to

pgsql-sql by date

Next:From: Jose AlarconDate: 2010-03-31 07:01:33
Subject: Re: SQL Developer accessing PostgreSQL
Previous:From: silly sadDate: 2010-03-30 04:48:23
Subject: Re: SQL Developer accessing PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group