Subselect with incorrect column not a syntax error? - Mailing list pgsql-general

From Mike Blackwell
Subject Subselect with incorrect column not a syntax error?
Date
Msg-id CANPAkgs-cUpD_QShLZ0moJP3=NNdQTW2ch6KBpnk=4pWCAZ=fA@mail.gmail.com
Whole thread Raw
Responses Re: Subselect with incorrect column not a syntax error?  (Jack Christensen <jackc@hylesanderson.edu>)
List pgsql-general
Could someone please explain to me why the following select does not
result in a syntax error?  (9.0.3)

begin;

create table x( c1 integer , c2 integer);
create table y( c3 integer, c4 integer);

select * from x where c2 in ( select c2 from y where c4 = 2 );


rollback;

Mike

pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Updating pg_attribute to change field's data type from integer to bigint on very large table
Next
From: Jack Christensen
Date:
Subject: Re: Subselect with incorrect column not a syntax error?