Hi all, I have just moved to PostgreSQL from MySQL and am willing to employ all the capabilities PostgreSQL has to offer. In MySQL I have had implemented Joe Celko's Nested Sets quite a while ago, extending them with some additional fields to cache data such as the level of the node and a reference to the parent node for better data manipulation. I don't feel like reinventing the wheel again in PostgreSQL by simply porting all the SQL from MySQL and not giving priority to stuff like stored procedures and referential integrity in postgres.
A search over google and these mailing lists have yielded little results, perharps I am missing something. Has anyone implemented a pretty Nested Sets solution in PostgreSQL? Or is this considered black voodoo and noone wants to show their solutions to the world? with regards, A. Kulikov -- The mind is essential -- http://essentialmind.com/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
