Thread: Normal distribution et al.?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

   Are there any statistical libraries for postgresql?

   I'd like to do something along the lines of:

   UPDATE foo SET value=value+normdistsample(10, 0.2) WHERE id=1;

- --
Kind regards,
Jan Danielsson

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (NetBSD)

iD8DBQFGdff2uPlHKFfKXTYRCmofAJ9Ni7CnVZdXuV13ppgKlU0ZFIG4zgCgkQF3
NzMyvu4td86RBlw4R+CX2C4=
=qgWi
-----END PGP SIGNATURE-----

On 6/18/07, Jan Danielsson <jan.m.danielsson@gmail.com> wrote:
>    UPDATE foo SET value=value+normdistsample(10, 0.2) WHERE id=1;
Something like this?
http://www.joeconway.com/plr/



-- Cheers,
   Andrej

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Andrej Ricnik-Bay wrote:
> On 6/18/07, Jan Danielsson <jan.m.danielsson@gmail.com> wrote:
>>    UPDATE foo SET value=value+normdistsample(10, 0.2) WHERE id=1;
> Something like this?
> http://www.joeconway.com/plr/

   That looks too good to be true.

   Many thanks!

- --
Kind regards,
Jan Danielsson

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (NetBSD)

iD8DBQFGdf65uPlHKFfKXTYRCiLVAKCTvgHVsWkH1wtTiqg4w8ieZeoR4wCeLuxn
Wo7L+94t2/4nP0gixz0q5fo=
=Koyh
-----END PGP SIGNATURE-----

On Mon, Jun 18, 2007 at 05:11:51AM +0200, Jan Danielsson wrote:
> Are there any statistical libraries for postgresql?
>
> I'd like to do something along the lines of:
>
> UPDATE foo SET value=value+normdistsample(10, 0.2) WHERE id=1;

Somebody else has mentioned PL/R.  For this particular example see
also normal_rand() in contrib/tablefunc.

--
Michael Fuhr

Jan Danielsson wrote:
> Andrej Ricnik-Bay wrote:
> > On 6/18/07, Jan Danielsson <jan.m.danielsson@gmail.com> wrote:
> >>    UPDATE foo SET value=value+normdistsample(10, 0.2) WHERE id=1;
> > Something like this?
> > http://www.joeconway.com/plr/
>
>    That looks too good to be true.
>
>    Many thanks!
>

See
http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgresql_plr_tut01

for a new intro, pretty basic, but a good place to start

Brent Wood