Syntax question: use of join/using with fully qualified table name

From: Bryce Nesbitt <bryce1(at)obviously(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Syntax question: use of join/using with fully qualified table name
Date: 2008-01-28 00:49:24
Message-ID: 479D2694.3090202@obviously.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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/

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Martin Marques 2008-01-28 01:43:04 Re: Syntax question: use of join/using with fully qualified table name
Previous Message Andrej Ricnik-Bay 2008-01-25 23:05:47 Re: Extract interdependent info from one table