Matthew Hixson wrote:
> Does Postgres have any native support for hierarchical data storage?
> I'm familiar with the Adjacency List technique, but am trying to
> determine whether or not Nested Sets would make sense for our
> application or not. I understand that Nested Sets might be better for
> high read applications, but write heavy applications suffer from poor
> performance.
You might find the "ltree" add-on in contrib useful. Look in the
"contrib" directory of your source installation, or the addons/extras
package of your distribution.
--
Richard Huxton
Archonet Ltd