Re: joined tables with USING and GROUPBY on the USING() column - Mailing list pgsql-general

From Geoff Winkless
Subject Re: joined tables with USING and GROUPBY on the USING() column
Date
Msg-id CAEzk6fcep41E3RAH67afj67bJZW_mEjPOJq=04-SH0cDkKvD0g@mail.gmail.com
Whole thread Raw
In response to Re: joined tables with USING and GROUPBY on the USING() column  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Thanks for the suggestions. Turns out I was right: I _was_ missing
something obvious - results had token as char(4), tokens had token as
varchar(4). Because the columns aren't the same they aren't treated as
identical so the query builder won't accept the unqualified name.

Next task is to work out how on earth the server ended up with its
results table different to all the others...

Geoff


pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: pgAdmin 4 records limit of 2000
Next
From: Adrian Klaver
Date:
Subject: Re: How to assemble all fields of (any) view into a string?