-----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)

iD8DBQFGdff2uPlHKFfKXTYRCmofAJ9Ni7CnVZdXuV13ppgKlU 0ZFIG4zgCgkQF3
NzMyvu4td86RBlw4R+CX2C4=
=qgWi
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

-----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)

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

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/PrinterFrie...ql_plr_t ut01

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

Brent Wood


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster