pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Support for "nested sets" and PHP (Re: Recursive select) 2+ messages / 2 participants [nested] [flat]
* Support for "nested sets" and PHP (Re: Recursive select) @ 2002-03-08 18:38 knut.suebert@web.de 0 siblings, 0 replies; 2+ messages in thread From: knut.suebert@web.de @ 2002-03-08 18:38 UTC (permalink / raw) To: pgsql-sql --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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Support for "nested sets" and PHP (Re: Recursive select) @ 2002-03-12 17:55 Culley Harrelson <Culley_Harrelson@pgn.com> 0 siblings, 0 replies; 2+ messages in thread From: Culley Harrelson @ 2002-03-12 17:55 UTC (permalink / raw) To: pgsql-sql; knut.suebert@web.de 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) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-03-12 17:55 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2002-03-08 18:38 Support for "nested sets" and PHP (Re: Recursive select) knut.suebert@web.de 2002-03-12 17:55 Support for "nested sets" and PHP (Re: Recursive select) Culley Harrelson <Culley_Harrelson@pgn.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox