debian man page for alzabo::sqlmaker::postgresql

Alzabo::SQLMaker::PostgreSQL(3pm)			User Contributed Perl Documentation			 Alzabo::SQLMaker::PostgreSQL(3pm)

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 func-
       tions (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>

perl v5.8.8							    2007-12-23					 Alzabo::SQLMaker::PostgreSQL(3pm)