Re: DAGs and recursive queries

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: DAGs and recursive queries
Дата
Msg-id 1190996937.5943.115.camel@dogma.ljc.laika.com
обсуждение исходный текст
Ответ на Re: DAGs and recursive queries  (Gregory Stark <stark@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: Mike Charnoky
Дата:
Сообщение: more problems with count(*) on large table
Следующее
От: Tom Lane
Дата:
Сообщение: Re: row->ARRAY or row->table casting?