Re: Update with ORDER BY and LIMIT - Mailing list pgsql-general

From Paul M Foster
Subject Re: Update with ORDER BY and LIMIT
Date
Msg-id 20110809153851.GG21240@quillandmouse.com
Whole thread Raw
In response to Re: Update with ORDER BY and LIMIT  (David Johnston <polobo@yahoo.com>)
Responses Re: Update with ORDER BY and LIMIT
List pgsql-general
On Mon, Aug 08, 2011 at 10:20:18PM -0400, David Johnston wrote:

>
> >
> > 8.X in this context means "8 point something, but I can't recall
> > which something". Could be 8.2, 8.3 or 8.4. Thus, in effect, asking
> > those replying to restrict themselves to 8 series features, as
> > opposed to 9 series features.
> >
>
> There are a lot of features added between 8.0 and 8.4;  WITH and
> WINDOW being two major ones, that just saying 8 is not helpful.  In
> the future please take the time to issue a SELECT pg_version() before
> asking others to take time to help.  It is for your own benefit and
> makes it easier for those wanting to help to give useful advice.

It'd be great if select pg_version() worked, but PG doesn't recognize
the function, when issued from the PG prompt. I had to go all the way
back to aptitude to find out it's verson 8.3.1-1 running under Debian
unstable.

Paul

--
Paul M. Foster
http://noferblatz.com
http://quillandmouse.com

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Problem with planner
Next
From: Tom Lane
Date:
Subject: Re: Problem with planner