Re: subqueries and qualification of table names

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kevin Murphy <murphy(at)genome(dot)chop(dot)edu>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: subqueries and qualification of table names
Date: 2005-04-27 03:37:30
Message-ID: 17416.1114573050@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kevin Murphy <murphy(at)genome(dot)chop(dot)edu> writes:
> ... In the following query, PG treats the phrase "and chromosome
> = chromosome" as "and genetic.chromosome = genetic.chromosome".

And that surprises you why?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-04-27 03:54:08 Re: Performance difference between ANY and IN, also array syntax
Previous Message Tatsuo Ishii 2005-04-27 02:42:26 Re: Pgpool questions