perl-SQL-Statement-Functions-ArgMinMax-0.002-alt1.noarch.rpm


Advertisement

Description

perl-SQL-Statement-Functions-ArgMinMax - ARGMIN*/ARGMAX* functions

Distribution: ALT Linux Sisyphus
Repository: Autoimports noarch
Package name: perl-SQL-Statement-Functions-ArgMinMax
Package version: 0.002
Package release: alt1
Package architecture: noarch
Package type: rpm
Installed size: 27.13 KB
Download size: 27.13 KB
Official Mirror: ftp.altlinux.org
This distribution contains several SQL functions to be used with the SQL::Statement manpage: 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 the fsql manpage: % fsql -F ARGMAXNUM --add-csv path/to/sometable.csv "SELECT ARGMAXNUM(col1,col2) FROM sometable ..."

Alternatives

Requires

Provides

  • perl(SQL/Statement/Function/ByName/ARGMAXNUM.pm) = 0.002
  • perl(SQL/Statement/Function/ByName/ARGMAXSTR.pm) = 0.002
  • perl(SQL/Statement/Function/ByName/ARGMINNUM.pm) = 0.002
  • perl(SQL/Statement/Function/ByName/ARGMINSTR.pm) = 0.002
  • perl(SQL/Statement/Functions/ArgMinMax.pm) = 0.002
  • perl-SQL-Statement-Functions-ArgMinMax = 0.002-alt1

    Install Howto

    1. Add the following line to /etc/apt/sources.list:
      rpm [Sisyphus] http://ftp.altlinux.org/pub/distributions/ALTLinux/autoimports/Sisyphus noarch autoimports
      rpm [Sisyphus] http://ftp.altlinux.org/pub/distributions/ALTLinux/autoimports/Sisyphus noarch autoimports
      
    2. Update the package index:
      # sudo apt-get update
    3. Install perl-SQL-Statement-Functions-ArgMinMax rpm package:
      # sudo apt-get install perl-SQL-Statement-Functions-ArgMinMax

    Files

    • /usr/share/doc/perl-SQL-Statement-Functions-ArgMinMax-0.002/Changes
    • /usr/share/doc/perl-SQL-Statement-Functions-ArgMinMax-0.002/LICENSE
    • /usr/share/doc/perl-SQL-Statement-Functions-ArgMinMax-0.002/README
    • /usr/share/perl5/SQL/
    • /usr/share/perl5/SQL/Statement/
    • /usr/share/perl5/SQL/Statement/Function/
    • /usr/share/perl5/SQL/Statement/Function/ByName/ARGMAXNUM.pm
    • /usr/share/perl5/SQL/Statement/Function/ByName/ARGMAXSTR.pm
    • /usr/share/perl5/SQL/Statement/Function/ByName/ARGMINNUM.pm
    • /usr/share/perl5/SQL/Statement/Function/ByName/ARGMINSTR.pm
    • /usr/share/perl5/SQL/Statement/Functions/ArgMinMax.pm
    Advertisement
    Advertisement