Guten Tag Lukas Eder, am Freitag, 7. Februar 2020 um 13:34 schrieben Sie: > Sure. But since this is a public list, with a few folks lurking, I always > like to open up discussions to broader topics[...]
And that's exactly how I understood your mail and why I brought my opinion into this discussion. I see these lists as a valuable place to document thoughts as well. > No, but it makes working with them easier, as they now behave like ordinary > tables / views. I still don't get it: There's no place where I can interchange CTEs and my custom tables, only reuse individual components. The only thing I can see working is what you say seems a bit unclear: > You could (but perhaps that does not appear to be very > clean) use your CTE definition in the WITH clause, but then reference your > CustomTable in the FROM clause and its columns in all other clauses. Or am I understanding your suggestion wrongly and I need to really implement CTE-SQL on my custom tables somehow? Like is done in the docs for custom fields, but I can't override "accept". https://www.jooq.org/doc/latest/manual/sql-building/queryparts/custom-queryparts/ Mit freundlichen Grüßen, Thorsten Schöning -- Thorsten Schöning E-Mail: [email protected] AM-SoFT IT-Systeme http://www.AM-SoFT.de/ Telefon...........05151- 9468- 55 Fax...............05151- 9468- 88 Mobil..............0178-8 9468- 04 AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow -- 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/1135177347.20200207152313%40am-soft.de.
