I think the WITH RECURSIVE query would be easier and more performant by
using pg_partition_tree and pg_partition_root.
--
Álvaro Herrera Valdivia, Chile — https://www.EnterpriseDB.com/
"Porque Kim no hacía nada, pero, eso sí,
con extraordinario éxito" ("Kim", Kipling)