Re: self referencing tables/ nested sets etc...

Поиск
Список
Период
Сортировка
От Rob Hoopman
Тема Re: self referencing tables/ nested sets etc...
Дата
Msg-id 200403251538.39928.rob@tuna.nl
обсуждение исходный текст
Ответ на Re: self referencing tables/ nested sets etc...  (Joe Conway <mail@joeconway.com>)
Список pgsql-general
Thank you both, I should have known to have look at the contribs first.


On Thursday 25 March 2004 06:37, Joe Conway wrote:
> Shawn Harrison wrote:
> > Forbes. But my own approach is to let the unique id of each object serve
> > as its "key" in the nested set key-chain (which I call its "ancestry"),
> > and separate the ids with path separator, e.g.:
>
> See connectby() in contrib/tablefunc. It produces much the same output
> dynamically.
>
> Joe
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

В списке pgsql-general по дате отправления:

Предыдущее
От: Alan Carbutt
Дата:
Сообщение: Re: Adding flexibilty to queries
Следующее
От: Mike Nolan
Дата:
Сообщение: Re: Adding flexibilty to queries