Alzabo::SQLMaker::PostgreSQL(3pm) | User Contributed Perl Documentation | Alzabo::SQLMaker::PostgreSQL(3pm) |
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" 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 DATE_TRUNC 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
These are functions which return information about the Postgres server.
CURRENT_USER SYSTEM_USER USER
These are flow control functions:
NULLIF COALESCE
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>
2021-01-08 | perl v5.32.0 |