v.21.2New Features
Add sign math function
Why it matters
Thesign function provides a simple way to determine the sign of a number, returning -1 for negative values, 0 for zero, and 1 for positive values. This helps users easily classify numbers based on their sign in queries and computations.How to use it
Use thesign function in your SQL queries by passing a numeric expression as an argument, for example:SELECT sign(column_name) FROM table_name;