It's a table valued function. You can use it in the FROM clause of your query. How else would you want to use it?
On Friday, April 12, 2024, suman choudhary <[email protected]> wrote: > Hi Lukas, > > > My stored procedure is returning a SET OF TEXT, but when Jooq reads from > the physical schema, it treats the stored procedure as a BASE TABLE instead > of a ROUTINE. Do you have any insights on why this might be occurring? > > > 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/CAE%3DEzhXH36VYyz_3uYQFdduONYxoGkvq-jLTcn_ > 1topWN%2BP7fg%40mail.gmail.com > <https://groups.google.com/d/msgid/jooq-user/CAE%3DEzhXH36VYyz_3uYQFdduONYxoGkvq-jLTcn_1topWN%2BP7fg%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/CAB4ELO4bfoh-7-AYPsG9QtCwaYJ1%3DAwnqCJXd-63buS1F2eEdQ%40mail.gmail.com.
