Stefan,

I understand how to create function from sql that receive value as input param(s). But how could i write sql function that receive array of values as input? For example i want to enable stdev function at algebra module, is it possible to do from sql?

Alex

Op 06-09-10 18:13, Alexandr Kulik schreef:
> I need to develop some extra statistical functions for MonetDB. I
> spent about a week to understand how to use function via sql, but
> still didn't have any succes results. May be someone could point me to
> appropriate documentation or source revision, where i could look on
> it?

You might be interested in these two files it shows how to add a module
to SQL written in the mx language:

http://kinkrsoftware.nl/contrib/monetdb/sphinx.mx
http://kinkrsoftware.nl/contrib/monetdb/sphinx.patch

After that you will still have to 'create function', but that is
relatively simple.


Stefan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.16 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEAREKAAYFAkyFFBUACgkQYH1+F2Rqwn1lRwCfe02Bjv3YozRMu3jaUug1bMgD
lXYAnAn3ktCoAEZGq7CEr0aCAfKRCWNs
=FNsy
-----END PGP SIGNATURE-----


--
With Best Regards Alexandr Kulik
Skype: kulya_u
Yahoo: kulya_u
LinkedIn: http://www.linkedin.com/in/alexandrkulik
Mobile: +3(806)615-40511