On Mon, Nov 20, 2017 at 4:26 PM, <tanes@siamscan.net> wrote: > Not sure if this is a bug or feature but when I query with sub select while > sub select has invalid column the query is still valid and running. For > example: > > create temp table a ( id integer, descr text); > create temp table b ( b_id integer, descr text); > > # select * from a where id=(select id from b where descr='A'); > > id | descr > ----+------- > (0 rows) > > # select id from b where descr='A'; > > ERROR: column "id" does not exist > LINE 1: select id from b where descr='A'; > ^
There is no bug here. The subquery should look at the column b_id which is defined for relation b, so the error is normal. -- Michael