SQL::Statement::Function::ByName::IF - SQL function to return a value or the other depending on condition
This document describes version 0.001 of SQL::Statement::Function::ByName::IF (from Perl distribution SQL-Statement-Functions-Logic), released on 2017-01-25.
In your SQL:
SELECT IF(cond, a, b) FROM table
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
Please visit the project's homepage at https://metacpan.org/release/SQL-Statement-Functions-Logic.
Source repository is at https://github.com/perlancar/perl-SQL-Statement-Functions-Logic.
Please report any bugs or feature requests on the bugtracker website https://rt.cpan.org/Public/Dist/Display.html?Name=SQL-Statement-Functions-Logic
When submitting a bug or request, please include a test-file or a patch to an existing test-file that illustrates the bug or desired feature.
perlancar <perlancar@cpan.org>
This software is copyright (c) 2017 by perlancar@cpan.org.
This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.
To install SQL::Statement::Functions::Logic, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SQL::Statement::Functions::Logic
CPAN shell
perl -MCPAN -e shell install SQL::Statement::Functions::Logic
For more information on module installation, please visit the detailed CPAN module installation guide.