News for hackers. Stuff that matters.

A comment on Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses.

Re:Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses by hestefisk on Thursday February 04, 2021 @08:02AM (#26024956)
Very valuable. Do other DBMSes have this feature? It’s quite incredible how much you can put the database to work. So much less application code to write.
[ Parent | on HN ]
Re:Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses by szarnyasg on Thursday February 04, 2021 @08:10AM (#26025004)
The authors of paper "Graph Processing in RDBMSs" surveyed graph features in 2017 among 4 popular systems:

http://sites.computer.org/debull/A17sept/p6.pdf (page 6, Table 1)

They found that only Oracle supported the CYCLE keyword, DB2 SQL Server, and Postgres (version 9 at the time) didn't. SQL Server now has a graph extension so that might have changed. MySQL has introduced support for WITH RECURSIVE in 2017 but it does not support the CYCLE keyword.

[ Parent | on HN ]
Re:Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses by hans_castorp on Thursday February 04, 2021 @08:12AM (#26025021)
I know that Oracle supports the CYCLE and the SEARCH clause in recursive CTEs
[ Parent | on HN ]