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 On Tue, 19 Mar 2024 at 4:19 PM, Lukas Eder <[email protected]> wrote: > Thanks for your message. > > Can you provide an example of what you're trying to do, please > > > On Tue, Mar 19, 2024 at 11:47 AM suman choudhary < > [email protected]> wrote: > >> Hi Lukas, >> >> Does JOOQ support custom functions that returns List? >> >> Thanks and Regards, >> Suman Choudhary >> >> -- >> 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 [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/jooq-user/42b6db7e-9e79-4ae9-a5e8-b542c8d85386n%40googlegroups.com >> <https://groups.google.com/d/msgid/jooq-user/42b6db7e-9e79-4ae9-a5e8-b542c8d85386n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/CAB4ELO6CCHRUzjJo4SVpxio8g58BvUcGw2VT7XJMbK2M0g79tw%40mail.gmail.com > <https://groups.google.com/d/msgid/jooq-user/CAB4ELO6CCHRUzjJo4SVpxio8g58BvUcGw2VT7XJMbK2M0g79tw%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAE%3DEzhUc64ZCKf%2Bt0PnG7EfYRqMC7R%2Br9fXxaoaYLdoLsbC2yg%40mail.gmail.com.
