</lurk> Ooh, I didn't know about either of those. Very, very sweet! And one for nested-sets and another for parent-links/adjacency lists.
This is what's so great about open source mailing lists -- the serendipity. Here on a Catalyst web-framework list you learn cool, tangential things about DBIC that you didn't know you were missing, and then you can just go nab new tools that make life easy! Awesome. On Thu, Dec 16, 2010 at 11:36 PM, Charlie Garrison <[email protected]>wrote: > Good morning, > > > On 16/12/10 at 11:15 AM -0500, Hauck, William B. <[email protected]> > wrote: > > Not sure how to do it in a DBIC-like fashion, but these few links show you >> how to do it in SQL for PostgreSQL and MySQL. Oracle and DB2 have >> hierarchical functionality built-in. >> >> http://www.postgresql.org/docs/8.4/static/queries-with.html >> >> http://dev.mysql.com/tech-resources/articles/hierarchical-data.html >> >> http://onlamp.com/lpt/a/5007 >> > > I haven't been following this thread closely, but I think one of the > DBIC::Tree modules is what OP is looking for: > > <http://search.cpan.org/perldoc?DBIx::Class::Tree::AdjacencyList> > <http://search.cpan.org/perldoc?DBIx::Class::Tree::NestedSet> > > > Charlie > > -- > Ꮚ Charlie Garrison ♊ <[email protected]> > > O< ascii ribbon campaign - stop html mail - www.asciiribbon.org > 〠 http://www.ietf.org/rfc/rfc1855.txt > > > _______________________________________________ > List: [email protected] > Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst > Searchable archive: > http://www.mail-archive.com/[email protected]/ > Dev site: http://dev.catalyst.perl.org/ > -- Failure is not important. How you overcome it, is. -- Nick Vujicic
_______________________________________________ List: [email protected] Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst Searchable archive: http://www.mail-archive.com/[email protected]/ Dev site: http://dev.catalyst.perl.org/
