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