persistence icon indicating copy to clipboard operation
persistence copied to clipboard

math functions in queries

Open gavinking opened this issue 3 years ago • 11 comments

The following functions are, I believe, supported on all major databases, and it seems to me that there would be value in adding them to the query language: power(), floor(), ceiling(), round(), sign(), ln(), exp(), sin(), cos(), tan(), asin(), acos(), atan(), atan2().

One might object that we don't typically need to do trigonometry in a typical query, and that's true, but since the databases themselves support these, along with both JDBC and ODBC in their function escape syntax, there's almost no cost to including these functions in the list.

If nobody objects to this idea, I will write up a proposal.

gavinking avatar May 05 '21 11:05 gavinking