Re: [GENERAL] Adjacency Lists vs Nested Sets

2007-07-10 Thread Michael Glaesemann
On Jul 10, 2007, at 13:51 , Richard Huxton wrote: 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.

Re: [GENERAL] Adjacency Lists vs Nested Sets

2007-07-10 Thread Richard Huxton
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

[GENERAL] Adjacency Lists vs Nested Sets

2007-07-10 Thread Matthew Hixson
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,