|
Alzabo::SQLMaker::PostgreSQL - Alzabo SQL making class for PostgreSQL |
Alzabo::SQLMaker::PostgreSQL - Alzabo SQL making class for PostgreSQL
use Alzabo::SQLMaker;
my $sql = Alzabo::SQLMaker->new( sql => 'PostgreSQL' );
PostgreSQL-specific SQL creation.
Almost all of the functionality inherited from Alzabo::SQLMaker is
used as is. The only overridden methods are limit and
get_limit, as PostgreSQL does allow for a LIMIT clause in its
SQL.
SQL may be imported by name or by tags. They take arguments as documented in the PostgreSQL documentation (version 3.23.39). The functions (organized by tag) are:
PI RANDOM ABD CEIL DEGREES FLOOR FACTORIAL SQRT CBRT EXP LN RADIANS ACOS ASIN ATAN ATAN2 COS COT SIN TAN ROUND TRUNC LOG POW MOD TO_CHAR
LENGTH CHAR_LENGTH CHARACTER_LENGTh OCTET_LENGTH TIRM UPPER LOWER INITCAP ASCII TO_ASCII STRPOS POSITION TO_NUMBER TO_DATE TO_TIMESTAMP REPEAT RPAD LPAD SUBSTR
NOW CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP TIMEOFDAY ISFINIT TIMESTAMP TO_CHAR DATE_PART EXTRACT OVERLAPS
BROADCAST HOST NETMASK MASKLEN NETWORK TEXT ABBREV
These are functions which operate on an aggregate set of values all at once.
COUNT AVG MIN MAX SUM STDDEV VARIANCE DISTINCT
These are functions which return information about the MySQL server.
CURRENT_USER SYSTEM_USER USER
These are functions which don't fit into any other categories.
ENCRYPT ENCODE DECODE FORMAT INET_NTOA INET_ATON BIT_OR BIT_AND PASSWORD MD5 LOAD_FILE
These are functions from other groups that are most commonly used.
NOW COUNT AVG MIN MAX SUM DISTINCT
Dave Rolsky, <dave@urth.org>
|
Alzabo::SQLMaker::PostgreSQL - Alzabo SQL making class for PostgreSQL |