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

From: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: joined tables with USING and GROUPBY on the USING() column
Date: 2016-09-07 20:11:53
Message-ID: CAEzk6fe9CDyQpHmX5RtPDDAFHRTtLmE24RAYn+oFxY1jxE8ScA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 7 Sep 2016 9:01 p.m., "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> wrote:
> What happens if you table qualify all the references to token?

Oh it definitely fixes it; I was more confused why it works on one server
and not another. I thought perhaps there was a config option to allow more
lax naming in this way. If not I'll have to look more closely at the table
defs, although I thought I had checked they were the same.

Geoff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-09-07 20:13:53 Re: joined tables with USING and GROUPBY on the USING() column
Previous Message Adrian Klaver 2016-09-07 20:01:10 Re: joined tables with USING and GROUPBY on the USING() column