Search results for "dist:SQL-Statement-Functions-Logic sql::statement"
SQL::Statement::Functions::Logic - Logic functions
This distribution contains several SQL functions to be used with SQL::Statement: IF() To use a function from Perl script: require SQL::Statement::Function::ByName::IF; $dbh->do(qq{CREATE FUNCTION IF NAME "SQL::Statement::Function::ByName::MAXNUM::SQL...
PERLANCAR/SQL-Statement-Functions-Logic-0.001 - 25 Jan 2017 06:33:35 UTC
SQL::Statement::Function::ByName::IF - SQL function to return a value or the other depending on condition
Caveat: the notion of true and false follows Perl's notion. Caveat: due to the current limitation of SQL::Parser, this function is not as useful as it should be, e.g. SQL::Parser cannot parse this correctly: SELECT IF(col > 10, a, b) FROM table...
PERLANCAR/SQL-Statement-Functions-Logic-0.001 - 25 Jan 2017 06:33:35 UTC