On Oct 20, 2007, at 21:24 , Richard Broersma Jr wrote:
I've seen ltree mentioned from time to time. Is it true that it
works with adjacency list model?
I don't believe so. I think it's path-based, but you can check it out
for yourself in contrib/
If the nested set model is chosen, would
--- On Sat, 10/20/07, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> Have you eliminated other approaches, such as arrays, ltree, etc?
Actually I haven't considered using arrays to store hierarchal information.
I've seen ltree mentioned from time to time. Is it true that it works with
adjacency lis
On Oct 20, 2007, at 7:33 , Merlin Moncure wrote:
On 10/19/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
Is it possible to constraint both the LEFT and RIGHT fields of a
record to use the same index? I am looking for a way to ensure
for all LEFTs and RIGHTs in a table, that is it is im
On 10/19/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> Is it possible to constraint both the LEFT and RIGHT fields of a record to
> use the same index? I am looking for a way to ensure for all LEFTs and
> RIGHTs in a table, that is it is impossible for any LEFT or RIGHT to have to
> same
On Oct 19, 2007, at 16:42 , Richard Broersma Jr wrote:
Is it possible to constraint both the LEFT and RIGHT fields of a
record to use the same index? I am looking for a way to ensure for
all LEFTs and RIGHTs in a table, that is it is impossible for any
LEFT or RIGHT to have to same value.
--- On Fri, 10/19/07, Scott Marlowe <[EMAIL PROTECTED]> wrote:
> > Is it possible to constraint both the LEFT and RIGHT
> > fields of a record to use the same index? I am looking for
> > a way to ensure for all LEFTs and RIGHTs in a table, that is
> > it is impossible for any LEFT or RIGHT to have
On Oct 19, 2007, at 7:37 PM, Scott Marlowe wrote:
On 10/19/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
Is it possible to constraint both the LEFT and RIGHT fields of a
record to use the same index? I am looking for a way to ensure
for all LEFTs and RIGHTs in a table, that is it is i
On 10/19/07, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> Is it possible to constraint both the LEFT and RIGHT fields of a record to
> use the same index? I am looking for a way to ensure for all LEFTs and
> RIGHTs in a table, that is it is impossible for any LEFT or RIGHT to have to
> same
