alzabo::sqlmaker::postgresql(3pm) [debian man page]

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)

Check Out this Related Man Page

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

NAME

       Alzabo::PostgreSQL - Alzabo and PostgreSQL

DESCRIPTION

       This documentation is about what special support Alzabo has for PostgreSQL, as well as what is lacking.

       Postgres support is based on the 7.3.x version of Postgres.  Alzabo should work with the 7.1 and 7.2 series, and may even work with the 7.0
       series.

       Mixed-case Table or Column Names

       By default, Postgres treats table and column names case-insensitively.  Because of this, Alzabo always quotes these names when generating
       DDL SQL.  If you are using tables or columns that contain upper-case characters, you should always call "$schema->set_quote_identifiers(1)"
       as soon as you load your schema object.	Otherwise, any method which generates DML SQL will fail.

       Reverse Engineering

       o   Alzabo cannot determine from the existence of a sequence that the sequence is meant to be used for a particular column unless the
	   sequence was created as a result of making a column's type SERIAL.

	   This is because there is no link between the two in the Postgres' data dictionary tables and will probably never change.

       Transactions

       o   Transactions are fully supported with Postgres.

       Outer joins

       o   Left and right outer joins are supported.

       o   Full outer joins are not supported.

       Constraints

       Column constraints can be specified as column attributes.  Table constraints can be specified as table attributes.

       Foreign key constraints are generated automatically based on the relationships defined by your schema.

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

Linux and UNIX Man Pages

alzabo::sqlmaker::postgresql(3pm) [debian man page]

Check Out this Related Man Page