Re: A MySQL Question

On Mon, 2008-12-08 at 19:46 -0600, Micah Gersten wrote: > Robert Cummings wrote: > > 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. > > > The function doesn't say who's doing the creating, it just checks for > the existence of the universe. How do you know? Are you... God? ;) Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP