pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Thomas Kellerer <spam_eater@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: SQL syntax rowcount value as an extra column in the result set
Date: Tue, 30 Mar 2010 10:03:35 +0200
Message-ID: <hosb8m$c6c$1@dough.gmane.org> (raw)
In-Reply-To: <594D625E4784AD4EA9D423E292BE6725E07CA0@mlbe2k10.cs.myharris.net>
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>

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




view thread (9+ messages)

Message-ID: <hosb8m$c6c$1@dough.gmane.org>
Permalink:  ../hosb8m$c6c$1@dough.gmane.org/
Also on:    postgresql.org/message-id/hosb8m$c6c$1@dough.gmane.org

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: spam_eater@gmx.net
  Subject: Re: SQL syntax rowcount value as an extra column in the result set
  In-Reply-To: <hosb8m$c6c$1@dough.gmane.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox