[ABS]
declaration=number
category=Numeric/Math Functions
description=The PostgreSQL abs function returns the absolute value of a number.
[AGE]
declaration=date1 and date2
category=Date/Time Functions
description=The PostgreSQL age function returns the number of years, months, and days between two dates.
[AVG]
declaration=expression1, expression2, ... expression_n,aggregate_expression,tables,WHERE conditions
category=Numeric/Math Functions
description=The PostgreSQL avg function returns the average value of an expression.
[BTRIM]
declaration=string,trim_character
category=String Functions
description=The PostgreSQL btrim function removes all specified characters from both the beginning and the end of a string.
[CEILING]
declaration=number
category=Numeric/Math Functions
description=The PostgreSQL ceiling function returns the smallest integer value that is greater than or equal to a number.
[CEIL]
declaration=number
category=Numeric/Math Functions
description=The PostgreSQL ceil function returns the smallest integer value that is greater than or equal to a number.
[CHARACTER_LENGTH]
declaration=string
category=String Functions
description=The PostgreSQL character_length function returns the length of the specified string.
[CHAR_LENGTH]
declaration=string
category=String Functions
description=The PostgreSQL char_length function returns the length of the specified string.
[COUNT]
declaration=expression1, expression2, ... expression_n,aggregate_expression,tables,WHERE conditions
category=Numeric/Math Functions
description=The PostgreSQL count function returns the count of an expression.
[CURRENT_DATE]
declaration=
category=Date/Time Functions
description=The PostgreSQL current_date function returns the current date.
[CURRENT_TIMESTAMP]
declaration=precision
category=Date/Time Functions
description=The PostgreSQL current_timestamp function returns the current date and time with the time zone.
[CURRENT_TIME]
declaration=precision
category=Date/Time Functions
description=The PostgreSQL current_time function returns the current time with the time zone.
[DATE_PART]
declaration=date,unit
category=Date/Time Functions
description=The PostgreSQL date_part function extracts parts from a date.
[DIV]
declaration=n,m
category=Numeric/Math Functions
description=The PostgreSQL div function is used for integer division where n is divided by m and an integer value is returned.
[EXP]
declaration=number
category=Numeric/Math Functions
description=The PostgreSQL exp function returns e raised to the power of number (or enumber).
[EXTRACT]
declaration=date,unit
category=Date/Time Functions
description=The PostgreSQL extract function extracts parts from a date.
[FLOOR]
declaration=number
category=Numeric/Math Functions
description=The PostgreSQL floor function returns the largest integer value that is equal to or less than a number.
[INITCAP]
declaration=string
category=String Functions
description=The PostgreSQL initcap function converts the first letter of each word to uppercase and all other letters are converted to lowercase.
[LENGTH]
declaration=string
category=String Functions
description=The PostgreSQL length function returns the length of the specified string, expressed as the number of characters.
[LOCALTIMESTAMP]
declaration=precision
category=Date/Time Functions
description=The PostgreSQL localtimestamp function returns the current date and time.
[LOCALTIME]
declaration=precision
category=Date/Time Functions
description=The PostgreSQL localtime function returns the current time.
[LOWER]
declaration=string
category=String Functions
description=The PostgreSQL lower function converts all characters in the specified string to lowercase.
[LPAD]
declaration=string,length,pad_string
category=String Functions
description=The PostgreSQL lpad function returns a string that is left-padded with a specified string to a certain length.
[LTRIM]
declaration=string,trim_character
category=String Functions
description=The PostgreSQL ltrim function removes all specified characters from the left-hand side of a string.
[MAX]
declaration=expression1, expression2, ... expression_n,aggregate_expression,tables,WHERE conditions
category=Numeric/Math Functions
description=The PostgreSQL max function returns the maximum value of an expression.
[MIN]
declaration=expression1, expression2, ... expression_n,aggregate_expression,tables,WHERE conditions
category=Numeric/Math Functions
description=The PostgreSQL min function returns the minimum value of an expression.
[MOD]
declaration=n,m
category=Numeric/Math Functions
description=The PostgreSQL mod function returns the remainder of n divided by m.
[NOW]
declaration=precision
category=Date/Time Functions
description=The PostgreSQL now function returns the current date and time with the time zone.
[POSITION]
declaration=substring,string
category=String Functions
description=The PostgreSQL position function returns the location of a substring in a string.
[POWER]
declaration=m,n
category=Numeric/Math Functions
description=The PostgreSQL power function returns m raised to the nth power.
[RANDOM]
declaration=
category=Numeric/Math Functions
description=The PostgreSQL random function can be used to return a random number or a random number within a range.
[REPEAT]
declaration=string,number
category=String Functions
description=The PostgreSQL repeat function repeats a string a specified number of times.
[REPLACE]
declaration=string,from_substring,to_substring
category=String Functions
description=The PostgreSQL replace function replaces all occurrences of a specified string.
[ROUND]
declaration=number,decimal_places
category=Numeric/Math Functions
description=The PostgreSQL round function returns a number rounded to a certain number of decimal places.
[RPAD]
declaration=string,length,pad_string
category=String Functions
description=The PostgreSQL rpad function returns a string that is right-padded with a specified string to a certain length.
[RTRIM]
declaration=string,trim_character
category=String Functions
description=The PostgreSQL rtrim function removes all specified characters from the right-hand side of a string.
[SETSEED]
declaration=seed
category=Numeric/Math Functions
description=The PostgreSQL setseed function can be used to set a seed for the next time that you call the random function. If you do not call setseed, PostgreSQL will use its own seed value. This may or may not be truly random. If you set the seed by calling the setseed function, then the random function will return a repeatable sequence of random numbers that is derived from the seed.
[SIGN]
declaration=number
category=Numeric/Math Functions
description=The PostgreSQL sign function returns a value indicating the sign of a number.
[SQRT]
declaration=number
category=Numeric/Math Functions
description=The PostgreSQL sqrt function returns the square root of a number.
[STRPOS]
declaration=string,substring
category=String Functions
description=The PostgreSQL strpos function returns the location of a substring in a string.
[SUBSTRING]
declaration=string,start_position,length
category=String Functions
description=The PostgreSQL substring function allows you to extract a substring from a string.
[SUM]
declaration=expression1, expression2, ... expression_n,aggregate_expression,tables,WHERE conditions
category=Numeric/Math Functions
description=The PostgreSQL sum function returns the summed value of an expression.
[TO_CHAR]
declaration=value,format_mask
category=Conversion Functions
description=The PostgreSQL to_char function converts a number or date to a string.
[TO_DATE]
declaration=string1,format_mask
category=Conversion Functions
description=The PostgreSQL to_date function converts a string to a date.
[TO_NUMBER]
declaration=string1,format_mask
category=Conversion Functions
description=The PostgreSQL to_number function converts a string to a number.
[TO_TIMESTAMP]
declaration=string1,format_mask
category=Conversion Functions
description=The PostgreSQL to_timestamp function converts a string to a timestamp.
[TRANSLATE]
declaration=string1,string_to_replace,replacement_string
category=String Functions
description=The PostgreSQL translate function replaces a sequence of characters in a string with another set of characters. However, it replaces a single character at a time. For example, it will replace the 1st character in the string_to_replace with the 1st character in the replacement_string. Then it will replace the 2nd character in the string_to_replace with the 2nd character in the replacement_string, and so on.
[TRIM]
declaration=leading,trailing,both,trim_character,string
category=String Functions
description=The PostgreSQL trim function removes all specified characters either from the beginning or the end of a string.
[TRUNC]
declaration=number,decimal_places
category=Numeric/Math Functions
description=The PostgreSQL trunc function returns a number truncated to a certain number of decimal places.
[UPPER]
declaration=string
category=String Functions
description=The PostgreSQL upper function converts all characters in the specified string to uppercase.
[XMLCONCAT]
declaration=xml
category=XML
description=concatenates a list of individual XML values to create a single value containing an XML content fragment