Re: Update with ORDER BY and LIMIT

Поиск
Список
Период
Сортировка
От Paul M Foster
Тема Re: Update with ORDER BY and LIMIT
Дата
Msg-id 20110809153851.GG21240@quillandmouse.com
обсуждение исходный текст
Ответ на Re: Update with ORDER BY and LIMIT  (David Johnston <polobo@yahoo.com>)
Ответы Re: Update with ORDER BY and LIMIT  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: Problem with planner
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Problem with planner