3 ms·
From where do you get that? I was searching the internets for this purported feature and couldn't find it. Link?
by jhoechtl 6y ago
From where do you get that? I was searching the internets for this purported feature and couldn't find it. Link?
- cldellow 6y agoVersion 14 adds some features to recursive CTE expressions to do BFS/DFS searches and cycle detection. As always, depesz has a nice write up of it: https://www.depesz.com/2021/02/04/waiting-for-postgresql-14-search-and-cycle-clauses/ https://www.depesz.com/2021/02/04/waiting-for-postgresql-14-... I _think_ it's just syntactic sugar and doesn't let you do anything you couldn't already do, although perhaps it would leave room in the future for the Postgres team to optimize query execution.