I'm wondering if anyone has (good or bad) experience with pg's composite types? They're supposed to allow getting hierarchical data as query results, right? Thi

I'm wondering if anyone has (good or bad) experience with pg's composite types? They're supposed to allow getting hierarchical data as query results, right? This and arrays should cover most 'simple' use cases?