| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: All hail Bob (not)!
Gene Wirchenko wrote:
> On Mon, 08 May 2006 08:02:42 GMT, Frank Hamersley
>>> jiiiiim_at_hotmail.com wrote: >>>> Frank Hamersley wrote: >>>>> Bob Badour wrote: >>>> [..] >>>> >>>>>> I agree it is no problem to write the query to get the average ages >>>>>> where the age is known. Using null, how does one write the query to >>>>>> get the correct result, ie. the average is unknown ? >>>>> select case when count(*) = count(age) >>>>> then avg(age) >>>>> else null >>>>> end as avgage >>>>> from table >>>> What say you Bob? The silence to date has been most instructive. >>>> >>>> Cheers, Frank. >>> Apparently, you do not know the meaning of plonk. I see you use two >>> email addresses. Plonk again.
>> >>> If you think it is appropriate to require the godawful mess above from a >>> casual user to get a correct result for a simple query, you only confirm >>> that you are an embecile.
>>
>>
An interesting comment and fair; cruel, but fair like Dinsdale. Clearly I was particularly identifying Bobs legendary abruptness with people he holds have nothing to contribute. However I will not resile from a style that hopefully has some wit and is more prosaic than simple utilitarian statements where possible. Even if the subject matter is dry the discussion can have a bit of colour IMO if it doesn't unduly affect the outcome.
> More flame and less smoke, please.
:-) I thought there was enough flame(ing) already and hence very little smoke.
What is it with Bob though? Its not like its a case of the Emperors New Clothes - rather its more like a second rate knot in the cravat yet no-one else seems inclined to point it out, or conversely even lambast me if my response is faulty.
Cheers, Frank. Received on Wed May 10 2006 - 07:49:49 CDT
![]() |
![]() |