pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / 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