[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