The list below is definitely not inclusive.
Younicycle gives you access to the majority of the standard PostgreSQL functions, along with a simple to use Editor. Functions are located within the Query Editor and are used with their own, dedicated 'Expressions' Editor.
Not shown below are User defined Functions which has its' own GUI - or - an Expression (function) - a way to Save a long expression - and then give it an alias. Doing this allows you to use an expression within another expression.
Not shown below are User defined Functions which has its' own GUI - or - an Expression (function) - a way to Save a long expression - and then give it an alias. Doing this allows you to use an expression within another expression.
Those Tricky Calculations
avg(arg1)count(arg1)min(arg1)max(arg1)sum(arg1)bit_and(expression)bit_or(expression)bool_and(expression)bool_or(expression)every(expression)
abs(arg1)acos(arg1)asin(arg1)atan(arg1)ceil(arg1)cos(arg1)cot(arg1)degrees(arg1)exp(arg1)floor(arg1)ln(arg1)log(arg1)pi()pow(arg1, arg2)radians(arg1)round(arg1)sin(arg1)sqrt(arg1)tan(arg1)
trim([leading | trailing | both] [characters] from arg)convert(arg1, [src_encoding name,] dest_encoding_name)lower(arg1)upper(arg1)length(arg1)md5(arg1)replace(arg1, from, to)substr(arg1, from[, count])
age(arg1)cur_date()cur_datetime()cur_time()get_periods(from_interval[, start_date[, actual_date]])
if(cond_expr, true_expr, false_expr)COALESCE(value [, ...])NULLIF(value1, value2))GREATEST(value [, ...])LEAST(value [, ...])
to_char(arg1,frmt_str)to_date(arg1,frmt_str)to_number(arg1,frmt_str)
array_append(anyarray, anyelement)array_cat(anyarray, anyarray)array_dims(anyarray)array_lower(anyarray, int)array_prepend(anyelement, anyarray)array_to_string(anyarray, text)array_upper(anyarray, int)string_to_array(text, text)
corr(Y, X)covar_pop(Y, X)covar_samp(Y, X)regr_avgx(Y, X)regr_avgy(Y, X)regr_count(Y, X)regr_intercept(Y, X)regr_r2(Y, X)regr_slope(Y, X)regr_sxx(Y, X)regr_sxy(Y, X)regr_syy(Y, X)stddev(expression)stddev_pop(expression)stddev_samp(expression)variance(expression)var_pop(expression)var_samp(expression)
di_moneylast(S, E, r)di_canspend(E, r, n)ii_moneylast(S, E, r, ss)ii_canspend(E, r, n, ss)
chart(name)barcode(code,fgcolor,bgcolor)image(imagename,foldername,schema)
Container Functions
Statistics Functions
Financial Functions
Array Functions
Formatting Functions (Casts)
String Functions
Date/Time Functions
Conditional Functions
Math Functions
Aggregate Functions
Many of these Functions are familiar to users of Excel or other desktop database apps such as Filemaker. The difference here is that it is available online - and it is a server application, allowing many simultaneous users.
PostgreSQL, the World's Most Advanced Open Source Database .... brought to the web.
PostgreSQL, the World's Most Advanced Open Source Database .... brought to the web.
See the bottom of this page for a screen shot.
Watch More
