This is exactly what I was looking for, could you post that please.
thx
B.
> On Sat, Jan 21, 2006 at 12:00:49AM +0100, SunWuKung wrote:
> > Does somebody have/know of a function for pg returning the standard
> > normal cumulative distribution for a Z score?
>
> Are you looking for something like this?
>
> test=> SELECT z, cdf_ugaussian_p(z) FROM generate_series(-3, 3) AS g(z);
> z | cdf_ugaussian_p
> ----+---------------------
> -3 | 0.00134989803163009
> -2 | 0.0227501319481792
> -1 | 0.158655253931457
> 0 | 0.5
> 1 | 0.841344746068543
> 2 | 0.977249868051821
> 3 | 0.99865010196837
> (7 rows)
>
> cdf_ugaussian_p() is just a little wrapper I put around the GNU
> Scientific Library's gsl_cdf_ugaussian_P() function. I can post
> an example of how to do that if it's what you're looking for.
>
>
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
