Subject RE: [firebird-support] Re: i want to this ; select avg(datefield) from ... but what?
Author Leyne, Sean
Kjell,

> > > I agree that it's a bit muddy, but it's not unthinkable, is it?
> >
> > I just can't find a meaning to it. It would look to me an
"arbitrary"
> value
> > with no use at all.
>
> Well let's say you have a real estate DB with a table describing when
> each hous has been repainted. You could select the last repaint from
> each house, group them by are, street or something, and then take the
> average of the date. That would indicate which area is in most need of
a
> new repaint.

I'm glad that you could come up with a good example... :-)

I think that the function should be allowed, but I was struggling to
come up with an example of its use.


Sean