Re: Joe Celko Function

Поиск
Список
Период
Сортировка
От Fran Fabrizio
Тема Re: Joe Celko Function
Дата
Msg-id 3CCFEF56.5000606@mmrd.com
обсуждение исходный текст
Ответ на Joe Celko Function  ("Ben-Nes Michael" <miki@canaan.co.il>)
Ответы Re: Joe Celko Function  (Ben-Nes Michael <miki@canaan.co.il>)
Список pgsql-general
To drop branches, I typically loop through this function.  But it would be easy to extend this case to drop an entire
branchat  
once.  You just need to know what the offset is.  If you are dropping a whole brach, it's actually an easier case,
becauseyou  
don't have to worry about shifting lower nodes on the branch (nodes that appear between the lft and rgt of the node you
dropped). 
  So if the lft is 50 and the rgt is 60, everyone else's numbers would just shift down 11. (The former lft 61 should
becomelft  
50, etc...).

-Fran



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

Предыдущее
От: "Ben-Nes Michael"
Дата:
Сообщение: Re: Joe Celko Function
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: Failed compile on Sun