Re: [BUGS] BUG #1540: Enhancement request: 'ambiguous' column reference in psql

2005-03-13 Thread Tom Lane
"Richard Neill" <[EMAIL PROTECTED]> writes: > SELECT instrument,priceband,pounds FROM tbl_instruments,tbl_prices WHERE > tbl_instruments.priceband=tbl_prices.priceband; > ERROR: column reference "priceband" is ambiguous > I think that the first query ought to succeed, since although priceband is

[BUGS] BUG #1540: Enhancement request: 'ambiguous' column reference in psql

2005-03-13 Thread Richard Neill
The following bug has been logged online: Bug reference: 1540 Logged by: Richard Neill Email address: [EMAIL PROTECTED] PostgreSQL version: 8.01 Operating system: Linux Description:Enhancement request: 'ambiguous' column reference in psql Details: Dear Postgresql te