select cs_sqrt((Open - Close) ^ 2.0) from Quote_get('IBM'); cs_sqrt ------------------------------------------------------------------------------------ float8:{0.300000190734863,0,0.299999237060547,0.299999237060547,0.299999237060547} (1 row) select cs_sin(Open)*cs_sin(Open) + cs_cos(Open)*cs_cos(Open) from Quote_get('IBM'); ?column? -------------------- float8:{1,1,1,1,1} (1 row) select cs_atan(cs_tan(Close)) from Quote_get('IBM'); cs_atan --------------------------------------------------------------------------------------------------- float8:{1.07522203923062,1.35044484140069,-1.21592577295848,-0.640703733727859,0.234517542563308} (1 row) select cs_asin(cs_sin(Close)) from Quote_get('IBM'); cs_asin --------------------------------------------------------------------------------------------------- float8:{-1.07522203923062,1.35044484140069,-1.21592577295848,0.640703733727859,0.234517542563308} (1 row) select cs_acos(cs_cos(Close)) from Quote_get('IBM'); cs_acos ------------------------------------------------------------------------------------------------ float8:{2.06637061435917,1.35044484140069,1.21592577295848,2.50088891986193,0.234517542563308} (1 row) select cs_log(cs_exp(Close/Open)) - Open/Close from Quote_get('IBM'); ?column? ------------------------------------------------------------------------------------------ float8:{0.0579832196235657,0,-0.0197697281837463,-0.0148699879646301,0.0119166374206543} (1 row) select cs_isnan(cs_parse('{-1,0,1}','float8')/0.0); cs_isnan -------------- char:{0,1,0} (1 row)