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
in perl at the moment...
guess my sql is not smart enough, but was thinking a user defined function
would be of great use :-)
any more suggestions?
tia!
-k
- Original Message
From: A. Kretschmer
To: pgsql-general@postgresql.org
Sent: Monday, April 6, 2009 4:53:28 AM
Subject: Re: [GENERA
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
