Support for "nested sets" and PHP (Re: Recursive select)

Поиск
Список
Период
Сортировка
От Culley Harrelson
Тема Support for "nested sets" and PHP (Re: Recursive select)
Дата
Msg-id sc8dd0c5.081@pgn.com
обсуждение исходный текст
Список pgsql-sql
There is this too:
 
http://freshmeat.net/projects/php-treeclass/

>>> <knut.suebert@web.de> 03/08/02 10:38AM >>>
--CELKO-- schrieb:
> The usual example of a tree structure in SQL books is called an
> adjacency list model and it looks like this:

> Another way of representing trees is to show them as nested sets.

Hello,

I thought a while about those nested sets to avoid recursive selects.
Made a few functions. Some of the expensive stuff seems to be solved
by introducing a 3rd column called "lvl".

If you are interested in, you can find it at

  http://www.net-one.de/~ks/WOoK/

by taking a look at "The PostrgreSQL side". Celko's original text is
also there.

Some stuff may be interesting for using PHP to edit PostgreSQL's
tables. But that part is incomplete, yet.

I'd be happy to get your thoughts to improve the handling (and my
understanding) of "nested sets".

Bye,
Knut Sübert

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

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

Предыдущее
От: "Andrew G. Hammond"
Дата:
Сообщение: Re: in-date news items
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: in-date news items