Waiting for PostgreSQL 14 – SEARCH and CYCLE clauses – select * from depesz;
Just as message suggests this change is related to recursive queries.Which means, that to test it, we need some data for recursive queries. This time I took directory listing of my /etc, and loaded it to db:Cool. Now let's see what these new changes get us.OK. So this returns the dirs, depth first, but ordered by id.Let's try to get the previous output, ascii-betical order, using this new approach, but also, let's see what ordercol really is:So, I can see now, that in this sort – etc/apparmor/X ...
Read more at depesz.com