On 2006-07-27 22:38:02 +0000, mock wrote:
> So I've got a function in my Pg database which takes a single
> parameter and returns a set of rows.
>
> "select * from function('param')" works just fine from psql and
> returns all my lovely rows just as I want them.
If 'param' is limited to only one or two values, the path of least
resistance is to create a view in your database and then treat it like
any other source in DBIx::Class.
Otherwise, you'll have to try 'from' attr hackery. See:
http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#from
--
Daniel Westermann-Clark
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/dbix-class@lists.rawmode.org/
