Re: Strange behavior on non-existent field in subselect?

From: Ken Tanzer <ktanzer(at)desc(dot)org>
To: Ragnar <gnari(at)hive(dot)is>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Strange behavior on non-existent field in subselect?
Date: 2006-10-18 21:59:25
Message-ID: 4536A3BD.9040506@desc.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks for the response Ragnar. I would have expected this query to
fail, since the sub-query doesn't work by itself:

>> SELECT foo_field FROM foo WHERE foo_field IN (SELECT foo_field FROM par);

But it obviously doesn't. So does that subselect implicitly read as:

IN (SELECT foo_field FROM par,foo);

Thanks for your help!

Ken

Attachment Content-Type Size
ktanzer.vcf text/x-vcard 342 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim C. Nasby 2006-10-18 22:22:58 Re: Real time query analyzer
Previous Message Ron Johnson 2006-10-18 21:27:21 Re: Real time query analyzer