SQL::Statement::FunctionsSQL::Statement::Functions are built-in & user-defined SQL functions. | |
Download |
SQL::Statement::Functions Ranking & Summary
Advertisement
- License:
- Perl Artistic License
- Price:
- FREE
- Publisher Name:
- Jeff Zucker
- Publisher web site:
- http://search.cpan.org/~timb/DBI-1.604/lib/DBD/DBM.pm
SQL::Statement::Functions Tags
SQL::Statement::Functions Description
SQL::Statement::Functions are built-in & user-defined SQL functions. SQL::Statement::Functions are built-in & user-defined SQL functions.SYNOPSIS SELECT Func(args); SELECT * FROM Func(args); SELECT * FROM x WHERE Funcs(args); SELECT * FROM x WHERE y < Funcs(args);This module contains the built-in functions for SQL::Parser and SQL::Statement. All of the functions are also available in any DBDs that subclass those modules (e.g. DBD::CSV, DBD::DBM, DBD::File, DBD::AnyData, DBD::Excel, etc.).This documentation covers built-in functions and also explains how to create your own functions to supplement the built-in ones. It's easy! If you create one that is generally useful, see below for how to submit it to become a built-in function.Function syntaxWhen using SQL::Statement/SQL::Parser directly to parse SQL, functions (either built-in or user-defined) may occur anywhere in a SQL statement that values, column names, table names, or predicates may occur. When using the modules through a DBD or in any other context in which the SQL is both parsed and executed, functions can occur in the same places except that they can not occur in the column selection clause of a SELECT statement that contains a FROM clause. # valid for both parsing and executing SELECT MyFunc(args); SELECT * FROM MyFunc(args); SELECT * FROM x WHERE MyFuncs(args); SELECT * FROM x WHERE y < MyFuncs(args); # valid only for parsing (won't work from a DBD) SELECT MyFunc(args) FROM x WHERE y; Requirements: · Perl
SQL::Statement::Functions Related Software