Postgres Pro
Downloads
Home   >   mailing lists

Re: GROUP BY or alternative means to group - Mailing list pgsql-general

From Scott Marlowe
Subject Re: GROUP BY or alternative means to group
Date
Msg-id CAOR=d=23=L6OX6MVRXCcAGit6J9EKwG-HjM2Go8Pv5eFcmHwyA@mail.gmail.com
Whole thread Raw
In response to Re: GROUP BY or alternative means to group  (Alexander Reichstadt <lxr@mac.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: "Nur Hidayat"
Date:
Subject: Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?
Next
From: John R Pierce
Date:
Subject: Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?