Horton

nested subselects are allowed

Zeugswetter Andreas <andreas.zeugswetter@telecom.at>

View thread
From: Zeugswetter Andreas DBT <Andreas.Zeugswetter@telecom.at>
To: "'pgsql-hackers@hub.org'" <pgsql-hackers@hub.org>
Date: 1998-01-12T10:25:00Z
Lists: pgsql-hackers 
> > >         select *
> > >         from tabA
> > >         where col1 = (select col2
> > >                       from tabB
> > >                       where tabA.col3 = tabB.col4
> > >                       and exists (select *
> > >                                   from tabC
> > >                                   where tabB.colX = tabC.colX and
> > >                                         tabC.colY = tabA.col2)
> > >                      )

I checked this in Informix, it works.

Andreas