Re: Adjacency List or Nested Sets to model file system hierarchy? - Mailing list 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,
);