Jesper Krogh wrote: > Hi.. I have a table with elements of the followin form > > prefixdigit ... such as: > abs123 > aasfdasdf91231231 > > Then I've created to immutable stored procedures in postgresql and created an > index on them: > > The stored procedures take the prefix in lower case and the digit. > > Thus. > > select element,prefix(element),digit(element) > gives (on Abs123). > > Abs123,abs,123 > > And using a select from the psql prompt makes Postgresql use the index: > > select * from table where prefix(element) = 'abs' and digit(element) > 100; > > How do I create this query using DBIx::Class? > > Jesper > Unless you have a *VERY* good reason to keep the fields as one, split them out into two separate fields.
Ash _______________________________________________ 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/[email protected]/
