Re: Query should have failed, but didn't? - Mailing list pgsql-general

On 02/03/2011, at 2:16 PM, Andy Colson wrote:

> Its getting id1 from the parent table.  (test2)   You can use fields from the parent table in subselects.
>
> try this and it'll complain:
>
> select * from test2 where id1 in (select junk from test1) and charge=70;

Oh!  Of course!  What a fool.  Thanks =)

--Royce