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/