man Alzabo::SQLMaker::PostgreSQL () - Alzabo SQL making class for PostgreSQL
NAME
Alzabo::SQLMaker::PostgreSQL - Alzabo SQL making class for PostgreSQL
SYNOPSIS
use Alzabo::SQLMaker;
my $sql = Alzabo::SQLMaker->new( sql => 'PostgreSQL' );
DESCRIPTION
PostgreSQL-specific SQL creation.
METHODS
Almost all of the functionality inherited from CWAlzabo::SQLMaker as is. The only overridden methods are CWlimit() and CWget_limit(), as PostgreSQL does allow for a CWLIMIT clause in its SQL.
EXPORTED SQL FUNCTIONS
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:
:math
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
:string
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
:datetime
NOW CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP TIMEOFDAY ISFINIT TIMESTAMP TO_CHAR DATE_PART EXTRACT OVERLAPS
:network
BROADCAST HOST NETMASK MASKLEN NETWORK TEXT ABBREV
:aggregate
These are functions which operate on an aggregate set of values all at once.
COUNT AVG MIN MAX SUM STDDEV VARIANCE
:system
These are functions which return information about the Postgres server.
CURRENT_USER SYSTEM_USER USER
:control
These are flow control functions:
NULLIF COALESCE
:misc
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
:common
These are functions from other groups that are most commonly used.
NOW COUNT AVG MIN MAX SUM DISTINCT
AUTHOR
Dave Rolsky, <dave@urth.org>