Re: Adjacency List or Nested Sets to model file system hierarchy?

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>, Bill Moseley <moseley(at)hank(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Adjacency List or Nested Sets to model file system hierarchy?
Date: 2007-02-12 15:21:38
Message-ID: 26708.16338.qm@web31806.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Can you describe in a little bit more detail about what you mean by
> 'Adjaceny LIst'?

Adjaceny list is the term used in the celko book to refer to a table that is recurively related to
itself.

create table foo (
id integer primary key,
parentid integer references foo (id),
name varchar not null,
);

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-02-12 15:53:53 Re: Adjacency List or Nested Sets to model file system hierarchy?
Previous Message Tom Lane 2007-02-12 14:43:13 Re: 8.2.3 initdb fails - invalid value for parameter "timezone_abbreviations": "Default"