>>>>> On Mon, 04 Nov 2002 15:03:48 +0100, Svein Erling Tysvaer <svein.erling.tysvaer@...> said:

SET> There is no need to return all rows within an EXISTS

Assuming Set meant "columns" here...

This is an open doubt, that maybe some one may solve: the docs suggest
using "IF EXISTS(SELECT * FROM atable WHERE akey=:akey)", but, as Set
says, it's a long time since I learned to avoid the star operator. I
always assumed that the server recognizes the EXISTS pattern and
optimize it as it can. Is this true, or should the doc and the
examples (and my SPs :) be corrected?

thanx, lele.
--
nickname: Lele Gaifax | Quando vivro' di quello che ho pensato ieri
real: Emanuele Gaifas | comincero' ad aver paura di chi mi copia.
email: lele@... | -- Fortunato Depero, 1929.