Re: [GENERAL] PostgreSQL code for nested sets

2005-01-16 Thread PFC
I'm wondering if anyone has taken the code from http://www.dbazine.com/tropashko4.shtml and converted it to PostgreSQL? You can use the contrib/ltree type, which represents a path, and will be easier and faster to use. http://www.sai.msu.su/~megera/postgres/gist/ltree/ Create a table

[GENERAL] PostgreSQL code for nested sets

2005-01-15 Thread Jim C. Nasby
I'm wondering if anyone has taken the code from http://www.dbazine.com/tropashko4.shtml and converted it to PostgreSQL? -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today

Re: [GENERAL] PostgreSQL code for nested sets

2005-01-15 Thread Michael Glaesemann
On Jan 16, 2005, at 15:20, Jim C. Nasby wrote: At least two. Here's one (blatant plug): http://www.grzm.com/fornow/archives/2004/07/10/static_hierarchies The other (which preceded mine) in the archives: http://archives.postgresql.org/pgsql-general/2003-12/msg00247.php The later Tropashko stuff is i