Re: A MySQL Question

On Tue, 2008-12-09 at 00:16 +0000, Nathan Rixham wrote: > Ashley Sheridan wrote: > > On Mon, 2008-12-08 at 23:23 +0000, ceo@l-i-e.com wrote: > >> Presumable, the EXISTS sub-query can be optimized sometimes to just stop processing > >> the sub-query and kick things back out to the outer query. > >> > >> > >> > >> IN has to process them all and find them all. > >> > >> > >> > > Don't forget the special case use as well: > > > > IF NOT EXISTS universe THEN bigbang() > > > > > > Ash > > www.ashleysheridan.co.uk > > > > any chance of writing the implementation of that bigbang() function? If nothing exists and a universe is created via a big bang... does it make a sound? Can we realistically call it a big bang if it doesn't make a sound? Couldn't we call it the big light show? But then again... if nothing exists and a universe is created via a big light show... does it matter? Can it be perceived? Is this just a proverbial pandrödinger's box? You can't implement the bigbang() function if you don't exist. Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP