[Dbix-class] using 'if' within where
Sung Gong
sung at bio.cc
Tue Jul 3 12:34:52 GMT 2012
Hi all,
Is it possible to use 'if' function within a where clause?
For example:
where if (column_a is null, 1, column_a>=10)
I know the sql can be registered as a custom resultset, but my case of
a bit complex (the number of binding values actually depends on the
number of parameters received).
SQL::Abstract does not explain the use of control flow functions.
Any help for this?
Regards,
Sung
More information about the DBIx-Class
mailing list