DESCRIPTION

    This distribution contains several SQL functions to be used with
    SQL::Statement:

     ARGMAXNUM()
     ARGMAXSTR()
     ARGMINNUM()
     ARGMINSTR()

    These functions are not aggregate functions. They are added due to the
    lack of CASE statement as well as IF function in SQL::Statement. For
    example, this SQL statement:

     SELECT CASE WHEN a > b THEN a ELSE b END FROM table

    can be expressed with:

     SELECT ARGMAXNUM(a, b) FROM table

    To use a function from Perl script:

     require SQL::Statement::Function::ByName::ARGMAXNUM;
     $dbh->do(qq{CREATE FUNCTION ARGMAXNUM NAME "SQL::Statement::Function::ByName::ARGMAXNUM::SQL_FUNCTION_ARGMAXNUM"});

    To use a function from fsql:

     % fsql -F ARGMAXNUM --add-csv path/to/sometable.csv "SELECT ARGMAXNUM(col1,col2) FROM sometable ..."

SEE ALSO

    SQL::Statement

    App::fsql