Hi Jiri, setp 2 of https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/UserDefinedFuncti... points to the source in sql/backends/monet5/UDF, i.e., http://dev.monetdb.org/hg/MonetDB/file/3d1e680be2d9/sql/backends/monet5/UDF there, in particular in udf.c, you find examples for both, the scalar and "bulk"/"BAT"/"table" versions of user-defined functions. Best, Stefan ----- Original Message -----
Hi all,
I’m trying to understand the example of user defined functions in MonetDB ( https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/UserDefinedFuncti... ).
I understand the concept for just reversing a string.
But what about working with tabular data? I’d like to pass to this C function a whole table (list of rows) and then return another table(s)/write result data to other tables.
What is the correct way of doing this? Can I pass some kind of arrays to the C function? Can I return these arrays from a function?
Or is it possible to query the DB directly from the C script?
Thank you very much for some answers.
Best regards,
Jiri Nadvornik
Astronomical Institute AV CR
Stellar department
Czech Republic
nadvornik.ji@gmail.com
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |