O Fabrice.Sznajderman@devoteam.com έγραψε στις Feb 15, 2006 :
> Hello, > > According to you, What it better to use, the IN or EXISTS predicat? > > I saw on internet it's better to use EXITS . but I would like to have > another point of view.. > > Thanks in advance
Prior to 7.4 IN was a looser, in 7.4 IN sometimes is by far a clear winner, i dunno in 8.*
> > > Fabrice > > +---------------------------------------------------------------------+ > About Devoteam: > > Devoteam is an IT consulting group. > Combining consulting and technology solutions offers enables > Devoteam to provide its customers with independent advice and > effective solutions to align their information system's technical > infrastructure with their operational objectives. > The group achieved a turnover of 199 million euros in 2005 > an operating margin of 7% and counts 2,100 employees through > 12 European countries and the Middle East. > Listed on the Euronext Paris Nouveau Marche and part of the Nexteconomy, > IT CAC, IT CAC 50, SBF 250 index of Euronext Paris. > www.devoteam.com > +---------------------------------------------------------------------+ >
-- -Achilleus
---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly