Date and Time functions
Millennium, Year, Quarter, Month, Week, Day, DayOfMonth, DayOfYear, DayOfWeek, Hour, Minute, Second, Millisecond
Conversion functions
SN
Math functions
Degrees, Abs, Mod, Pi, Radians, Random, ACos, ASin, Cos, Cot, Sin, Tan, Cbrt, Ceiling, Div, Exp, Floor, Ln, Log, Power, Round, Sign, Sqrt, ATan, ATan2
Operators
+, -, *, /, %
Statistical functions
Sum, Avg, Min, Max, First, Last, Count, UniqueCount, Corr, Covar_pop, Regr_avgx, Regr_avgy, Regr_count, Regr_intercept, Regr_r2, Regr_slope, Regr_sxx, Regr_sxy, Regr_syy, Stddev, Stddev_pop, Stddev_samp, Variance, Var_pop, Var_samp
Text functions
Concat, Initcap, LeftStr, Length, Lower, LTrim, Md5, RightStr, RTrim, Repeat, Replace, Reverse, Strpos, Trim, Upper, Bit_length, Char_length, Octet_length, Btrim, Chr, To_ascii, To_hex, Substr, Translate, Convert, Convert_From, Convert_To
Binning
Binning is supported.
See also:
Details on PostgreSQL Connection