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 -- Jesper Krogh _______________________________________________ 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]/
