Subselect with incorrect column not a syntax error?

From: Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Subselect with incorrect column not a syntax error?
Date: 2012-04-13 16:39:10
Message-ID: CANPAkgs-cUpD_QShLZ0moJP3=NNdQTW2ch6KBpnk=4pWCAZ=fA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Adams 2012-04-13 16:43:08 Re: Updating pg_attribute to change field's data type from integer to bigint on very large table
Previous Message Steve Crawford 2012-04-13 16:31:16 Re: Updating pg_attribute to change field's data type from integer to bigint on very large table