Re: In or Exists?

Thank for your answer!

I use 7.3. I think it the same between 7.4 and 7.3?

Fabrice

Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Envoyé par : pgsql-jdbc-owner(at)postgresql(dot)org
15/02/2006 16:57

A
Fabrice(dot)Sznajderman(at)devoteam(dot)com
cc
pgsql-jdbc(at)postgresql(dot)org, <pgsql-jdbc-owner(at)postgresql(dot)org>
Objet
Re: [JDBC] In or Exists?

O Fabrice(dot)Sznajderman(at)devoteam(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly