The following are the functions that the PostgreSQL connector supports.
Supported functions are the functions that you can use when you work with in-database data tables, for example for calculated columns and custom expressions.
Important: Some supported functions might not be possible to use with your database. This depends on what functions are available in the database, which often differs between database versions and types
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, Scale, ACos, ACosd, ASin, ASind, Cos, Cosd, Cot, Cotd, Sin, Sind, Tan, Tand, Cbrt, Ceiling, Div, Exp, Floor, Ln, Log, Power, Round, Sign, Sqrt, ATan, ATand, ATan2, ATan2d
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
Other supported functionality
Binning
Stored procedures
Note: Stored procedures that do not result in a data table output will not be visible in the Views in Connection dialog for some connectors. The schema of the stored procedure must not change from time to time (for example, the use of parameters must not change the schema).