[Dbix-class] Index-lookup in where clause.. Indexed stored procedure.

Matt S Trout dbix-class at trout.me.uk
Tue Jul 11 14:45:43 CEST 2006


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?

Probably using a literal SQL chunk; SQL::Abstract isn't as smart as it might 
be about handling functions in the WHERE clause.

-- 
      Matt S Trout       Offering custom development, consultancy and support
   Technical Director    contracts for Catalyst, DBIx::Class and BAST. Contact
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

+ Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +



More information about the Dbix-class mailing list