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


Advertisement

Description

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

Property Value
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

Package Version Architecture Repository
perl-SQL-Statement-Functions-ArgMinMax - - -

Requires

Name Value
/usr/share/perl5 -
perl(List/Util.pm) -
perl-base >= 1:5.10.1
rpmlib(PayloadIsLzma) -

Provides

Name Value
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

Download

Type URL
Binary Package perl-SQL-Statement-Functions-ArgMinMax-0.002-alt1.noarch.rpm
Source Package perl-SQL-Statement-Functions-ArgMinMax-0.002-alt1.src.rpm

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

Path
/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

See Also

Package Description
perl-SQL-Statement-Functions-Date-0.04-alt1.noarch.rpm More date/time functions
perl-SQL-Statement-Functions-Logic-0.001-alt1.noarch.rpm Logic functions
perl-SQL-Steno-0.2-alt1.noarch.rpm Short hand for SQL and compact output
perl-SQL-String-0.02-alt1.noarch.rpm An object representation of a chunk of SQL
perl-SQL-Template-0.2.4-alt1.noarch.rpm A new way to organize your database code
perl-SQL-Translator-Producer-DBIxSchemaDSL-0.04-alt1.noarch.rpm DBIX::Schema::DSL specific producer for SQL::Translator
perl-SQL-Translator-Producer-GoogleBigQuery-0.01-alt1.noarch.rpm Google BigQuery specific producer for SQL::Translator
perl-SQL-Translator-Producer-GraphQL-0.04-alt1.noarch.rpm GraphQL schema producer for SQL::Translator
perl-SQL-Translator-Producer-PlantUML-0.05-alt1.noarch.rpm It's new $module
perl-SQL-Translator-Producer-Teng-0.03-alt1.noarch.rpm Teng-specific producer for SQL::Translator
perl-SQL-TwoWay-0.05-alt1.noarch.rpm Run same SQL in valid SQL and DBI placeholder
perl-SQL-Type-Guess-0.03-alt1.noarch.rpm guess an appropriate column type for a set of data
perl-SQL-YASP-0.12-alt1.noarch.rpm SQL::YASP - SQL parser and evaluater
perl-SQL-Yapp-2.002-alt1.noarch.rpm SQL syntax in Perl with compile-time syntax checks
perl-SQLayer-1.1-alt1.noarch.rpm perl module SQLayer
Advertisement
Advertisement