----- Original Message ----- > From: "Sándor Halász" <h...@tbbs.net> > > Does the _function_ 'IF' always evaluate its arguments? or only the > two that it is needful to evaluate?
I'm afraid I'm not authoritative on this, but it seems to me that it would be very very bad if the third, unused expression were to be evaluated - not only from a performance point of view, but who is to say that that expression is not a user-defined function that modifies the database ? -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org