Hello! I tried to search info on supporting by JOOQ of common table expressions and recursive ones (for hierarchical queries), but didn't find too much info. I found http://blog.jooq.org/2011/10/02/recursive-queries-with-oracles-connect-by-clause/ with some promises about applying oracle syntax ("In the near future, jOOQ is going to project the CONNECT BY syntax and API to other RDBMS’s Common Table Expression syntax. That way, you can express hierarchical queries in any database supporting CTE’s using Oracle’s CONNECT BY syntax.")
So at all: does JOOQ support CTE (it may be useful in oracle too for other reasons than hierarchical queries), recursive CTE or another syntax for hierarchical queries in other databases than Oracle? (for now I need PostgreSQL and MSSQL Server) Thank you, Nkolay -- 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]. For more options, visit https://groups.google.com/groups/opt_out.
