-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Felix LUNGU Sent: Thursday, December 05, 2002 12:27 AM To: Victor Pendleton; [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] > Sent: Wednesday, December 04, 2002 9:22 AM > To: [EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php