[MonetDB-users] Stored Procedures in MonetDB
Hi all,
would it be possible to let us know whether MonetDB/SQL supports stored procedures and provide us with pointers to the features supported (e.g., recursion).
Many Thanks Irini
---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.
Hi Irini,
sorry for our delayed reply!
Yes, MonetDB/SQL does support stored procedures (user defined functions) follwing the SQL standard syntax as given at http://monetdb.cwi.nl/SQL/Documentation/Functions.html
Next to implementing functions in SQL itself, it is also possible to implement functions in MAL (or even C) and register them as "external" UDF as described here: http://monetdb.cwi.nl/SQL/Documentation/External-Functions.html
The documentation in particular for the latter might be a bit short. Sorry. Please do not hesitate to contact us (preferably again via this mailing list) in case you have more questions.
(At least) for the time being, UDFs in MonetDB/SQL do not support recursion.
Stefan
On Wed, Feb 16, 2011 at 05:41:18PM +0200, Irini Fundulaki wrote:
Hi all,
would it be possible to let us know whether MonetDB/SQL supports stored procedures and provide us with pointers to the features supported (e.g., recursion).
Many Thanks Irini
This message was sent using IMP, the Internet Messaging Program.
The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: Pinpoint memory and threading errors before they happen. Find and fix more than 250 security defects in the development cycle. Locate bottlenecks in serial and parallel code that limit performance. http://p.sf.net/sfu/intel-dev2devfeb _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Irini Fundulaki
-
Stefan.Manegold@cwi.nl