The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

Search results for "dist:SQL-Statement-Functions-Logic sql::statement"

SQL::Statement::Functions::Logic - Logic functions River stage one • 1 direct dependent • 1 total dependent

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 River stage one • 1 direct dependent • 1 total dependent

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
2 results (0.038 seconds)