Subject | aggregate udf |
---|---|
Author | msarossy |
Post date | 2009-01-13T06:17:22Z |
I would like to connect to a FB2.1 database and run an aggregate query
which returns mean and standard deviation. Is it possible to write a
UDF which can take part in such a query. If so, what is passed to the
UDF which would need an array of unspecified size
the query would be something like
select avg(uv), stdev(uv) from results where step = 1 ;
where stdev is the udf
marc
which returns mean and standard deviation. Is it possible to write a
UDF which can take part in such a query. If so, what is passed to the
UDF which would need an array of unspecified size
the query would be something like
select avg(uv), stdev(uv) from results where step = 1 ;
where stdev is the udf
marc