Thanks. Will give it a try. Executing two queries can also be done without a user defined function. So what might be the benefit in that case?
On Friday, 20 July 2012 17:58:58 UTC+2, Thomas Mueller wrote: > > Hi, > > You could create a user defined function (a Java function) that runs both > queries. > > Regards, > Thomas > > > On Tuesday, July 17, 2012, Johannes Schneider wrote: > >> Hi guys, >> >> those statements work for me: >> >> select >> set(@VAR_MILLIS_MIN ,min(millis)) AS MILLIS_MIN, >> set(@VAR_MILLIS_DELTA ,max(MILLIS) - min(MILLIS)) as MILLIS_DELTA >> from HISTORICAL.DATAPOINTS D >> where D.MILLIS between 100000000 and 101000000 AND PVID=25; >> >> select PVID, floor(((MILLIS-@VAR_MILLIS_MIN)/(@VAR_MILLIS_DELTA+ >> 0.00000001))*3) AS flooredMillis, min(millis),max(millis),max(numbervalue), >> min(numbervalue) >> from >> HISTORICAL.DATAPOINTS >> where MILLIS between 100000000 and 101000000 AND PVID=25 >> group by flooredMillis >> order by flooredMillis >> >> But now I would like to merge this functionality into one statement that >> I can use as prepared statement. Any ideas how this could be done? >> The main problem seems to be, that I am using calculated values from the >> first query in the column definition of the second one... >> >> -- >> You received this message because you are subscribed to the Google Groups >> "H2 Database" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/h2-database/-/bUzGGgm98d0J. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/h2-database?hl=en. >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/1fX21L8BTXMJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
