I have a simple schema and query for a MWE.
CREATE TABLE ttable ( tcol Numeric(19,4) )
INSERT INTO ttable (tcol) VALUES ('123.45678'); SELECT * FROM ttable;
In this case, I have lost precision. I entered five decimal places, but Postgres automatically rounded down to four. I want this to be an error, or at least a warning of some kind that I can detect, so that I can tell the user about the loss of precision.
How can I make this happen?
This question is obviously not a duplicate of this question. In that question, the user is using a client application which is rounding value below the stored precision. My question is about Postgres itself rounding the data to fit, not the client displaying. This would be obvious to anyone who looked further than the title of both questions.