Provided by: libalzabo-perl_0.92-6_all bug

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 "Alzabo::SQLMaker" as is.  The only
       overridden methods are "limit()" and "get_limit()", as PostgreSQL does allow for a "LIMIT"
       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
        DATE_TRUNC
        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>