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

-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |