joined tables with USING and GROUPBY on the USING() column

Поиск
Список
Период
Сортировка
От Geoff Winkless
Тема joined tables with USING and GROUPBY on the USING() column
Дата
Msg-id CAEzk6fe3iNSDj9p2YhpTQJtHB7KjLVBZnAb5PCxCf3Wca2Wr2A@mail.gmail.com
обсуждение исходный текст
Ответы Re: joined tables with USING and GROUPBY on the USING() column  (John R Pierce <pierce@hogranch.com>)
Re: joined tables with USING and GROUPBY on the USING() column  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
I'll start by saying that I'm sure I'm missing something obvious...

I have a query that is working fine on all my servers except one. The
only obvious difference is that the failing one is running 9.5.3,
while most are running 9.5.4, but since the query works on a 9.5.1 box
I also have I can't imagine that's the cause.

I can simplify the query (and still retain the error) down to:

SELECT results.token FROM results INNER JOIN tokens USING(token) GROUP BY token;

ERROR: column "results.token" must appear in the GROUP BY clause or be
used in an aggregate function

All well and good, and I'm happy enough to change the query's GROUP BY
to include the table name, but it's confusing me how it works OK on
all servers except one.

Is there some configuration option I'm missing?

Thanks!

Geoff


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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: PostgreSQL Database performance
Следующее
От: John R Pierce
Дата:
Сообщение: Re: joined tables with USING and GROUPBY on the USING() column