See list Latest Jan - July old

Functions Editor

AGGREGATES - every(expression) - sum(arg1) - bit_and(expression) - count(arg1) - min(arg1) - bool_or(expression) - bool_and(expression) - avg(arg1) - max(arg1) - bit_or(expression) ARRAYS - array_append(anyarray, anyelement) - array_cat(anyarray, anyarray) - array_dims(anyarray) - array_to_string(anyarray, text) - array_lower(anyarray, int) - array_prepend(anyelement, anyarray) - array_upper(anyarray, int) - string_to_array(text, text) CONDITIONAL - NULLIF(value1, value2)) - COALESCE(value [, ...]) - if(cond_expr, true_expr, false_expr) - GREATEST(value [, ...]) - CASE WHEN condition THEN result [WHEN ...] [ELSE result] END - CASE expression WHEN value THEN result [WHEN ...] [ELSE result] END - LEAST(value [, ...]) DATA TYPE FORMATTING - to_date(text, text) - cast(value as data_type) - to_timestamp(double precision) - to_timestamp(text, text) - to_number(text, text) - to_char(timestamp, text) - to_char(interval, text) - to_char(integer, text) - to_char(double precision, text) - to_char(numeric, text) DATE & TIME - clock_timestamp() - date_part(text, timestamp|interval) - date_trunc(text, timestamp) - extract(field from timestamp) - get_periods(from_interval[, start_date[, actual_date]]) - current_time - justify_interval(interval) - isfinite(timestamp|interval) - localtime - current_timestamp - transaction_timestamp() - age(timestamp[, timestamp]) - current_date - justify_days(interval) - justify_hours(interval) - now() - statement_timestamp() - localtimestamp - timeofday() FINANCIAL - di_moneylast(S, E, r) - di_canspend(E, r, n) - FVPMT(payment, interestRate, periods) - ii_moneylast(S, E, r, ss) - ii_canspend(E, r, n, ss) - FVPMT2(payment, interestrate, periods) MATH - log(b numeric, x numeric) - random() - round(v numeric[, s int]) - setseed(dp) - sign(x numeric) - sqrt(x numeric) - trunc(v numeric[, s int]) - width_bucket(op numeric, b1 numeric, b2 numeric, count int) - mod(y, x) - ln(x dp numeric) - floor(x numeric) - exp(x numeric) - degrees(dp) - ceiling(x numeric) - ceil(x numeric) - cbrt(dp) - abs(x) - power(a numeric, b numeric) - pi() - radians(dp) QUERY BUILDER - prompt(param name) STATISTICS - var_samp(expression) - var_pop(expression) - stddev_samp(expression) - variance(expression) - stddev_pop(expression) - stddev(expression) - regr_syy(Y, X) - regr_sxy(Y, X) - regr_sxx(Y, X) - regr_slope(Y, X) - regr_r2(Y, X) - regr_intercept(Y, X) - regr_count(Y, X) - regr_avgy(Y, X) - regr_avgx(Y, X) - covar_samp(Y, X) - covar_pop(Y, X) - corr(Y, X) STRING - position(substring in string) - character_length(string) - char_length(string) - bit_length(string) - chr(code) - substr(arg1, from[, count]) - replace(arg1, from, to) - overlay(string placing string from int [for int]) - decode(string text, type text) - upper(arg1) - lower(arg1) - convert_to(string text, dest_encoding name) - convert_from(string bytea, src_encoding name) - convert(arg1, [src_encoding name,] dest_encoding_name) - ltrim(string text [, characters text]) - rtrim(string text [, characters text]) - regexp_split_to_array(string text, pattern text [, flags text ]) - regexp_matches(string text, pattern text [, flags text]) - regexp_replace(string text, pattern text, replacement text [, flags text]) - lpad(string text, length int [, fill text]) - rpad(string text, length int [, fill text]) - repeat(string text, number int) - triminvisibles(string) - split_part(string text, delimiter text, field int) - initcap(string) - substring(string from pattern [for escape]) - substring(string [from int] [for int]) - trim([leading | trailing | both] [characters] from arg) - md5(arg1) - length(arg1) - regexp_split_to_table(string text, pattern text [, flags text]) - encode(data bytea, type text) - octet_length(string) TRIGONEMTRIC - atan2(y, x) - sin(x) - cot(x) - cos(x) - tan(x) - atan(x) - asin(x) - acos(x) WINDOW FUNCTIONS - ntile(num_buckets integer) - cume_dist() - nth_value(value any, nth integer) - dense_rank() - row_number() - lead(value any [, offset integer [, default any ]]) - first_value(value any) - last_value(value any) - lag(value any [, offset integer [, default any ]]) - rank()