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)
