Skip to content
Advertisement

How to clamp a float in PostgreSQL

I have a number 1.00000001, and I want to clamp it between -1 and 1 to avoid input out of range error on ACOS() function. An MCVE look like this:

My ideal would be something like:

Advertisement

Answer

The solution I found was:

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement