News for hackers. Stuff that matters.
Re:Writing an Interpreter in SQL for Fun and No Profit [video] by zamalek on Tuesday June 04, 2019 @02:46PM (#20098004)
I love the JSON-as-a-parser hack.

In TSQL (MS SQL Server) it would run into the CTE recursion limit; I'm not sure if Postgres is any different in this regard. I suspect that this could be solved and optimized with a WHILE loop and, most likely, something similar to ORDPATH[1].

[1]: http://www.dbis.informatik.hu-berlin.de/fileadmin/lectures/W..., https://github.com/mejedi/libordpath

Re:Writing an Interpreter in SQL for Fun and No Profit [video] by the_angry_angel on Tuesday June 04, 2019 @05:31PM (#20099469)
FWIW in MSSQL there’s always the `option (maxrecursion 0)` trick
Re:Writing an Interpreter in SQL for Fun and No Profit [video] by hobs on Tuesday June 04, 2019 @07:40PM (#20100255)
Also other cursors, and GOTO statements :)