ambiguous

From: si <s(at)remail(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: ambiguous
Date: 2001-03-07 15:38:32
Message-ID: 20010307153832.D1D6F274E@sitemail.everyone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

If I assign the same name to 2 columns in 2 different tables:

+--------------------------------------+
| DEPARTMENT |
+----------+----------------+----------+
| LOCATION | DESCRIPTION | DEPT_NO |
+----------+----------------+----------+
| Bedrock | Administration | 1 |
+----------+----------------+----------+

+--------------------------------+
| EMPLOYEE |
+---------+------------+---------+
| EMPL_ID | NAME_LAST | DEPT_NO |
+---------+------------+---------+
| 1 | Slate | 1 |
+---------+------------+---------+

select * from DEPARTMENT, Employee where dept_no = '1';

PG throws up:
ERROR: Column 'dept_no' is ambiguous

Is this not allowed? or is my sql understanding wrong?

_____________________________________________________________
Pick up your email anywhere in the world ---> http://www.remail.net

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-03-07 15:42:46 Re: Why are tables sizes so big?
Previous Message Boulat Khakimov 2001-03-07 15:19:44 Re: (blowfish in Postgres) Undefined symbol -- YAY!