Re: GROUP BY or alternative means to group

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Alexander Reichstadt <lxr(at)mac(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: GROUP BY or alternative means to group
Date: 2012-03-12 21:40:30
Message-ID: CAOR=d=23=L6OX6MVRXCcAGit6J9EKwG-HjM2Go8Pv5eFcmHwyA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Mar 12, 2012 at 3:19 PM, Alexander Reichstadt <lxr(at)mac(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2012-03-12 21:42:10 Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?
Previous Message Nur Hidayat 2012-03-12 21:28:04 Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?