Hi,
I'd like to create functional indexes on some columns..
ie. The raw sql would be:
CREATE TABLE foo (bar TEXT);
CREATE INDEX foo_bar_idx ON foo( lower(bar) );
I'm trying to set this up via a DBIC Schema using sqlt_deploy_hook().
Is there a way?
I've tried
$sqlt_table->add_index(
fields => ['lower(bar)']
);
and
$sqlt_table->add_index(
fields => { lower => 'bar' }
);
but neither worked, and I can't see much that looks like it'll work in:
http://search.cpan.org/~jrobinson/SQL-Translator-0.11007/lib/SQL/Translator/Schema/Index.pm
Any suggestions?
Thanks,
Toby
_______________________________________________
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]
