Hi all,

I’m trying to understand the example of user defined functions in MonetDB (https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/UserDefinedFunction).

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