On Thu, Sep 15, 2011 at 6:38 AM, Richard Hipp <d...@sqlite.org> wrote:
> On Wed, Sep 14, 2011 at 9:03 PM, Sam Carleton <scarle...@miltonstreet.com > >wrote: > > > Forgive me, fore I have forgotten the term used to describe the behavior > if > > a C if statement where it stops executing on the first false statement, > > but... Does coalesce do that? > > > > "Short-circuit evaluation" is the usual term applied to this kind of thing, > and yes, COALESCE() does short-circuit evaluation. If you say > "coalesce(A,B)" and A is not NULL than B is never evaluated, which can be a > significant performance win if, for example, B is a complex subquery. > Richard, Thank you! I did look on the web site to see if it said anything about whether or not coalesce implemented short-circuit evaluations, but it did not say one way or another. How would I go about suggesting that change on the web site? Sam _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users