Recursion with SQL
Does Caché have any features similar to PostgreSQL 'WITH RECURSIVE'? Something that allows recursion in SQL.
Discussion (3)2
Log in or sign up to continue
https://community.intersystems.com/post/recursion-sql
Hi Lucas!
I hope you can manage this with custom class queries enveloping this into a stored procedure.
Learn more here
@Benjamin De Boe , @Wolf Koelling, @Eduard Lebedyuk any hint?
No, we indeed don't support that syntax feature. Like Evgeny said, this recursion is something we'd typically try to wrap inside ObjectScript methods, which you could then expose as a stored procedure.
Thank you Evgeny and Benjamin for answering.
I used the method store procedure to solve this recursion problem.