Home > mailing lists

Re: count distinct and group by - Mailing list pgsql-general

From	Geoff Winkless
Subject	Re: count distinct and group by
Date	May 7, 2015 14:00:14
Msg-id	CAEzk6fdVFzmY6_+yBbKk+Qd9YUWns5-QHZ-UP7zc08TqdG5eug@mail.gmail.com Whole thread Raw
In response to	Re: count distinct and group by (Thomas Kellerer <spam_eater@gmx.net>)
List	pgsql-general

Tree view

On 7 May 2015 at 11:54, Thomas Kellerer <spam_eater@gmx.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

pgsql-general by date:

From: Thomas Kellerer
Date: 07 May 2015, 13:56:52
Subject: Re: count distinct and group by

From: cchee-ob
Date: 07 May 2015, 19:33:05
Subject: Re: Getting UDR up and running

Re: count distinct and group by - Mailing list pgsql-general

Previous

Next