I have a function in my database that I want to call without a table.
Ie, I want to issue the query:
SELECT uuid.get_parent('663288c6-2cbf-11df-9818-7f00ea0e1477');
And not:
SELECT uuid.get_parent('663288c6-2cbf-11df-9818-7f00ea0e1477') from
uuid.master;
My current code gives the latter query:
$schema->resultset('UuidMaster')->search(
{},
{ select => [ { 'uuid.get_parent' => "'$uuid'" } ],
as => [qw(top)],
});
--
Jason Armstrong
_______________________________________________
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]
