In or Exists?

From: Fabrice(dot)Sznajderman(at)devoteam(dot)com
To: pgsql-jdbc(at)postgresql(dot)org, pgsql-jdbc-owner(at)postgresql(dot)org
Subject: In or Exists?
Date: 2006-02-15 14:36:10
Message-ID: OF7ED5CB03.6C08F1B7-ONC1257116.004FF4F1-C1257116.00506D6B@devoteam.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

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
+---------------------------------------------------------------------+

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Fabrice.Sznajderman 2006-02-15 15:11:48 Re: In or Exists?
Previous Message Achilleus Mantzios 2006-02-15 14:21:05 Re: When to close a Statement