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?
On Tue, Mar 19, 2024 at 1:08 PM suman choudhary <choudharysuman...@gmail.com> wrote: > 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 <lukas.e...@gmail.com> 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 < >> choudharysuman...@gmail.com> 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 jooq-user+unsubscr...@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 >>> <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 jooq-user+unsubscr...@googlegroups.com. >> 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 jooq-user+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/CAE%3DEzhUc64ZCKf%2Bt0PnG7EfYRqMC7R%2Br9fXxaoaYLdoLsbC2yg%40mail.gmail.com > <https://groups.google.com/d/msgid/jooq-user/CAE%3DEzhUc64ZCKf%2Bt0PnG7EfYRqMC7R%2Br9fXxaoaYLdoLsbC2yg%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 jooq-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO5tJ6xgcJ1yS8tsyMjPKV2E4s3%3DVAMW%2B5d-Bk_xw%2B%2BL7g%40mail.gmail.com.
