Re: count distinct and group by

From: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: count distinct and group by
Date: 2015-05-07 10:59:54
Message-ID: CAEzk6fdVFzmY6_+yBbKk+Qd9YUWns5-QHZ-UP7zc08TqdG5eug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7 May 2015 at 11:54, Thomas Kellerer <spam_eater(at)gmx(dot)net> wrote:

> Geoff Winkless schrieb am 07.05.2015 um 12:39:
> > in Postgres (unlike MySQL) you can't order a list of values by a column
> you haven't selected.​
>
> Of course you can, just not when you are aggregating.
>
> ​Doh! I missed out that key clause :)

Thanks for correcting me.

Geoff​

In response to

Browse pgsql-general by date

  From Date Subject
Next Message cchee-ob 2015-05-07 16:32:56 Re: Getting UDR up and running
Previous Message Thomas Kellerer 2015-05-07 10:54:46 Re: count distinct and group by