On Sun, 5 Apr 2009, Kashmir wrote:
would it possible at all to create a percentile-aggregate in pgres?
I normally just do this right in the database without specifically
accelerating it with an aggregate. Not very efficient but it works fine
for reasonably sized data sets that fit into the
Kashmir wrote:
>
> thx for anwering!,
>
> i was more looking for a percentile calculation as in
> http://en.wikipedia.org/wiki/Percentile
> usually i do this in perl with the 'Statistics::Descriptive' module,
> but it would help me alot if i could solve this within the sql query,
> and would no
L] user defined aggregate for percentile calculations
In response to Kashmir :
>
> cant seem to find anything about this,
> would it possible at all to create a percentile-aggregate in pgres?
> any pointers?
> tia
> -k
I'm not sure if i understand your problem, but how ab
In response to Kashmir :
>
> cant seem to find anything about this,
> would it possible at all to create a percentile-aggregate in pgres?
> any pointers?
> tia
> -k
I'm not sure if i understand your problem, but how about:
test=*# select * from percentile ;
id | value
+---
1 |10
cant seem to find anything about this,
would it possible at all to create a percentile-aggregate in pgres?
any pointers?
tia
-k
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
