Question
Lucas Fernandes · Nov 27, 2019

Recursion with SQL

Does Caché have any features similar to PostgreSQL 'WITH RECURSIVE'? Something that allows recursion in SQL.
 

00
0 3 188 3

Replies

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.