Re: Do FROM items of different schemas conflict?

From: Joe Conway <mail(at)joeconway(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: Do FROM items of different schemas conflict?
Date: 2002-03-09 00:30:15
Message-ID: 3C895797.7020207@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Joe Conway <mail(at)joeconway(dot)com> writes:
>
>>This works in Oracle 8.1.6
>>
>
> So what does Oracle do with
>
> select plan_table.operation from apps.plan_table, cyapps.plan_table;
>
> ??
>

SQL> select plan_table.operation from apps.plan_table, cyapps.plan_table;

select plan_table.operation from apps.plan_table, cyapps.plan_table

ORA-00918: column ambiguously defined

Joe

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Fernando Nasser 2002-03-09 00:57:24 Re: Do FROM items of different schemas conflict?
Previous Message Tom Lane 2002-03-09 00:29:29 Re: Do FROM items of different schemas conflict?