db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Segel <mse...@segel.com>
Subject Re: functions and list
Date Wed, 02 Nov 2005 17:44:34 GMT
On Wednesday 02 November 2005 10:09, Rick Hillegas wrote:
Sorry to top post. 
(I know just how important net etiquette is these days... ;-)

> Hi Nicolas,
> In old releases of Cloudscape, customers were able to create their own
> aggregates. This functionality was removed from Derby probably because
> the syntax was considered non-standard. Most of the machinery for this
> feature is still in the code and it should be easy to re-enable once we
> agree on acceptable syntax. I have logged enhancement request 672 to
> track this issue.
> Regards,
> -Rick
Uhmmm I'm not sure its a question of user defined aggregates. The question was 
AVG, MAX, pretty much the norm.

I'm looking at the version 10 doc (dated Apr 12 2005) [Reference Manual]
and there seems to be a whole slew (beaucoup), of built in functions?

Among them... MAX, COUNT, AVG, SUM, ... well you get the idea.

Now its a pity that you removed extensibility. I guess the question is, should 
Derby be like other databases that contain extensions to SQL92?
But thats another story... ;-) 

> Nicolas Dufour wrote:
> > Hi
> >
> > I wonder how I can create an aggregate function like count or max ?
> > The idea is i want to process in the same time a list of row and
> > return something.
> > For example, I need to get from a list of flights (rows of table
> > flight) the average delay.
> >
> > Is it possible in Derby and how ?
> >
> > Thank you
> >
> > Nicolas
Interesting that you chose airlines. Thats the examples found in the reference 

Michael Segel

View raw message