| From: | Zeugswetter Andreas DBT <Andreas(dot)Zeugswetter(at)telecom(dot)at> |
|---|---|
| To: | "'pgsql-hackers(at)hub(dot)org'" <pgsql-hackers(at)hub(dot)org> |
| Subject: | nested subselects are allowed |
| Date: | 1998-01-12 10:25:00 |
| Message-ID: | 219F68D65015D011A8E000006F8590C60F2526@sdexcsrv1.sd.spardat.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | neil d. quiogue | 1998-01-12 11:59:30 | Re: [QUESTIONS] libpq and db information |
| Previous Message | Vadim B. Mikheev | 1998-01-12 09:40:48 | Re: [HACKERS] Re: subselects |