Problem Statement

PostgreSQL and some competitors have a round function that accepts a second parameter indicating a desired number of decimal places.
Came across a company that has queries using this syntax and they need to rework them to work with CrateDB.

Possible Solutions

Implement the function as in https://www.postgresql.org/docs/8.1/functions-math.html

Considered Alternatives

• UDF
• more complex expression like round (v *100)/100.0