Alzabo::SQLMaker::PostgreSQL.3pm

Langue: en

Autres versions - même langue

Version: 2008-06-10 (ubuntu - 07/07/09)

Section: 3 (Bibliothèques de fonctions)

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>