In PostgreSQL,I would like to store signed value -999.9~9999.9. For this, can I use numeric(5.1)? Or, what type should I use? Please give your any advice. Thank in advance.
Take the 2-minute tour
×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
numeric(5.1)
will be OK. See the documentation for details. – Simon MᶜKenzie 2 hours agonumeric
is part of the sql standard, and yes, it's signed. – Simon MᶜKenzie 2 hours ago