[Dbix-class] sql function in left side of where

[Marc Logghe]

> -----Original Message-----
> From: Ulrich Leodolter [mailto:ulrich.leodolter at univie.ac.at] 
> Sent: Saturday, February 10, 2007 1:37 PM
> To: dbix-class at lists.rawmode.org
> Subject: [Dbix-class] sql function in left side of where
> 
> hello
> 
> i've read DBIx::C:Manual and SQL::Abstract, but found now 
> answer how to make a ResultSet search for the following sql query:
> 
> SELECT date FROM my_table WHERE YEAR( date ) = ?
> 

Here one can find some info on using functions and stored procedures
http://search.cpan.org/~jrobinson/DBIx-Class-0.07005/lib/DBIx/Class/Resu
ltSet.pm#select

HTH,
Marc