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/
