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