-----Original Message-----
From: lungu@stripped [mailto:lungu@stripped]On
Behalf Of Felix LUNGU
Sent: Thursday, December 05, 2002 12:27 AM
To: Victor Pendleton; mysql@stripped
Subject: Re: Aggregating function which returns more than one row
The idea is simple:
I want to implement some temporal computation
on timeseries like normalization and interpolation
to smooth the data and fill the missing values.
So, for example if have a table like that:
starttime,endtime,counter
12:00,12:30,34
13:00,14:00,25
you see that for 12:00 the measurement was for
30 minutes and a segement is missing (12:30-13:00).
What I want is to write some aggregation functions
the will do this kind of computations like the following:
select nisum(starttime,endtime,counter,<interval>,trashold) from <my_table>
where ....
That's it,
Felix
-------
sql, query
Victor Pendleton wrote:
> Felix,
> Can you please give an example of what you are attempting to do?
>
> -----Original Message-----
> From: Felix LUNGU [mailto:felix.lungu@stripped]
> Sent: Wednesday, December 04, 2002 9:22 AM
> To: mysql@stripped
> Subject: Aggregating function which returns more than one row
>
> Is is it possible to write an aggregation function which returns
> more than one row?
>
> Thanks,
> felix
>
> Mysql sql query
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread126543@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-VPendleton=hoovers.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <mysql-thread126655@stripped>
To unsubscribe, e-mail <mysql-unsubscribe-gcooper=mhc.ab.ca@stripped>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
