That's called a view. Use that keyword when searching. Though, I'd seriously consider refactoring your schema.
On Thu, Jun 17, 2010 at 09:56, Dave Howorth <[email protected]> wrote: > Is there way to present a merged view of some tables using DBIx::Class? > > Imagine I have three tables: > > pig ( > pig_id INT, > pig_name TEXT, > colour ENUM ('brown', 'black', 'white), > ); > > cow ( > cow_id INT, > cow_name TEXT, > colour ENUM ('brown', 'black', 'white), > ); > > sheep ( > sheep_id INT, > sheep_name TEXT, > colour ENUM ('brown', 'black', 'white), > ); > > What's more, the values of pig_id, cow_id and sheep_id are disjoint. > > I'd like DBIC to present them as though they were a single table > > animal ( > id INT, > name TEXT, > colour ENUM ('brown', 'black', 'white), > ); > > Is there some way to do that? > > Thanks, Dave > > _______________________________________________ > List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class > IRC: irc.perl.org#dbix-class > SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ > Searchable Archive: http://www.grokbase.com/group/[email protected] > -- Thanks, Rob Kinyon _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
