Subject | RE: [firebird-support] Re: i want to this ; select avg(datefield) from ... but what? |
---|---|
Author | Leyne, Sean |
Post date | 2008-05-21T14:24:38Z |
Kjell,
I think that the function should be allowed, but I was struggling to
come up with an example of its use.
Sean
> > > I agree that it's a bit muddy, but it's not unthinkable, is it?"arbitrary"
> >
> > I just can't find a meaning to it. It would look to me an
> valuea
> > 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
> 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