Does jooq support user defined functions ?

[suman choudhary]

Hi Lukas,

Does JOOQ support custom functions that returns List?

Thanks and Regards,

Suman Choudhary

[Lukas Eder]

Thanks for your message.

Can you provide an example of what you're trying to do, please

--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/42b6db7e-9e79-4ae9-a5e8-b542c8d85386n%40googlegroups.com.

[suman choudhary]

Hi Lukas,

Below is the sample custom function 

CREATE OR REPLACE FUNCTION get_employee_names() RETURNS TABLE (name text) AS $$ BEGIN RETURN QUERY SELECT name FROM employees; END; $$ LANGUAGE plpgsql;

Regards,

Suman Choudhary 

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO6CCHRUzjJo4SVpxio8g58BvUcGw2VT7XJMbK2M0g79tw%40mail.gmail.com.

[Lukas Eder]

Hi Suman,

The code generator supports generating this function, and you can then use it in a query, yes. Do you have a specific question about this?

To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAE%3DEzhUc64ZCKf%2Bt0PnG7EfYRqMC7R%2Br9fXxaoaYLdoLsbC2yg%40mail.gmail.com.