Re: A MySQL Question

On Tue, Dec 9, 2008 at 3:51 PM, Micah Gersten <micah@onshore.com> wrote: > German Geek wrote: > > On Tue, Dec 9, 2008 at 2:46 PM, Micah Gersten <micah@onshore.com > > <mailto:micah@onshore.com>> 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 > > <mailto: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 > > >>> <http://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. > > > > Lol, I agree, the function bigbang() doesn't need to be implemented > > (or it could be empty if it needs to be there for this line to work), > > because by definition, the universe must exist, if this statement is > > to exist. > Who says this statement is run in this universe? Who says it's not for > a simulator? > > > > Guys, I think this is taking it a bit far... > > You new here? ;) > Yep. I'm new here. :) OK, to take this even further then... How about a start of a high level function: function bigbang() { $elementsNecessaryForBang = God::createElements(); // have to get it from somewhere, don't know how to get this just yet $particleSimulator = new ParticleSimulator($elementsNecessaryForBang); $particleSimulator->start(); // ... return $universe; } Oh, I forgot. We're writing this in plain MySQL? Don't know how to even start this... :) I guess this is a PHP List, so I guess it's safe to use PHP, no? Sorry for stealing the thread...