Good morning,
On 16/12/10 at 11:15 AM -0500, Hauck, William B.
<william.ha...@ibx.com> 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 ♊ <garri...@zeta.org.au>
O< ascii ribbon campaign - stop html mail - www.asciiribbon.org
〠 http://www.ietf.org/rfc/rfc1855.txt
_______________________________________________
List: Catalyst@lists.scsys.co.uk
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
Dev site: http://dev.catalyst.perl.org/