Thread: How to Make aggragate Function? Standard Deviation?

How to Make aggragate Function? Standard Deviation?

From
"Phillip J. Allen"
Date:
Hi all,

I am just starting to write functions in plpgsql.  I have made some
simple functions but now I need a standard deviation function.  The
documentation was not too clear so does anyone have any suggestion on
how to begin?  I can do this in plpgsql or do I need to do this in C?

thanks,

Phillip J. Allen
Consulting Geochemist/Geologist
Lima Peru
e-mail: paallen@attglobal.ent


Re: How to Make aggragate Function? Standard Deviation?

From
Jason Earl
Date:
What version of PostgreSQL are you using?  Version 7.1
has stddev() built right in (I don't believe it was
available in the 7.0 series, and I can guarantee it
wasn't in the 6.5 series).  I use it all of the time.

SELECT stddev(weight) FROM caseweights1;

Jason

--- "Phillip J. Allen" <paallen@attglobal.net> wrote:
> Hi all,
>
> I am just starting to write functions in plpgsql.  I
> have made some
> simple functions but now I need a standard deviation
> function.  The
> documentation was not too clear so does anyone have
> any suggestion on
> how to begin?  I can do this in plpgsql or do I need
> to do this in C?
>
> thanks,
>
> Phillip J. Allen
> Consulting Geochemist/Geologist
> Lima Peru
> e-mail: paallen@attglobal.ent
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/