Re: GROUP BY or alternative means to group

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: GROUP BY or alternative means to group
Дата
Msg-id CAOR=d=23=L6OX6MVRXCcAGit6J9EKwG-HjM2Go8Pv5eFcmHwyA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: GROUP BY or alternative means to group  (Alexander Reichstadt <lxr@mac.com>)
Список pgsql-general
On Mon, Mar 12, 2012 at 3:19 PM, Alexander Reichstadt <lxr@mac.com> wrote:
> But where would I insert the max(address) piece?
>

Just put max() or min() around any field in the select list that's not
in the group by clause

В списке pgsql-general по дате отправления:

Предыдущее
От: "Nur Hidayat"
Дата:
Сообщение: Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?
Следующее
От: John R Pierce
Дата:
Сообщение: Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?