Recursion with SQL
Does Caché have any features similar to PostgreSQL 'WITH RECURSIVE'? Something that allows recursion in SQL.
Discussion (3)2
Comments
Hi Lucas!
I hope you can manage this with custom class queries enveloping this into a stored procedure.
@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.