Re: DAGs and recursive queries - Mailing list pgsql-general

From Jeff Davis
Subject Re: DAGs and recursive queries
Date
Msg-id 1190996937.5943.115.camel@dogma.ljc.laika.com
Whole thread Raw
In response to Re: DAGs and recursive queries  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-general
On Thu, 2007-09-27 at 23:58 +0100, Gregory Stark wrote:
> It keeps the same information in more than one place. Consider:
>
> 1
> 1.1
> 1.1.1
>
> Note that all three records contain the root's id of "1". If you want to
> reparent 1.1 to be 2.1 you have to know that all its children also need to be
> reparented as well.

Aren't there still some update anomolies with any schema representing a
DAG?

Regards,
    Jeff Davis


pgsql-general by date:

Previous
From: Mike Charnoky
Date:
Subject: more problems with count(*) on large table
Next
From: Tom Lane
Date:
Subject: Re: row->ARRAY or row->table casting?