On Thu, Sep 15, 2011 at 10:05 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > Documentation for COALESCE is here: > > http://www.sqlite.org/lang_corefunc.html > > It does not say whether it does short-circuit evaluation but the description > does imply testing one by one, rather than evaluating all the conditions > first.
Simon, I don't mean to be difficult, but I simply don't get any indication of how exactly COALESCE actually functions from this description: "coalesce(X,Y,...) The coalesce() function returns a copy of its first non-NULL argument, or NULL if all arguments are NULL. Coalesce() must be at least 2 arguments. " I get there has to be at least two arguments, but no where do I see where it states it only executes an argument if all the previous one fail. Now it would be crystal clear if it said something like: "coalesce(X,Y,...) The coalesce() function returns a copy of its first non-NULL argument, or NULL if all arguments are NULL. Coalesce() must be at least 2 arguments. Coalesce() does use short-circuit evaluation." Sam _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users