From: Bryce Nesbitt <bryce1@obviously.com>
To: pgsql-sql@postgresql.org
Subject: Syntax question: use of join/using with fully qualified table name
Date: Sun, 27 Jan 2008 16:49:24 -0800
Message-ID: <479D2694.3090202@obviously.com> (raw)
I've got a join where a certain column name appears twice:
select username,last_name from eg_member join eg_membership using
(member_id) join eg_account using (account_id) join eg_person using
(person_id);
ERROR: common column name "person_id" appears more than once in left table
My first inclination was to fully quality the table name. Why would
this not be acceptable syntax?
select username,last_name from eg_member join eg_membership using
(member_id) join eg_account using (account_id) join eg_person using
(eg_member.person_id);
ERROR: syntax error at or near "." at character 145
Of course I eventually wrote it:
select username,last_name from eg_member join eg_membership using (member_id) join eg_account using (account_id) join eg_person on eg_member.person_id=eg_person.person_id';
PostgreSQL 8.1.9 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.1.1 20070105 (Red Hat 4.1.1-51)
--
----
Visit http://www.obviously.com/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bryce1@obviously.com
Subject: Re: Syntax question: use of join/using with fully qualified table name
In-Reply-To: <479D2694.3090202@obviously.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox