22003 PostgreSQL Origin: Data Last updated 14 Oct 2026

ERROR: numeric field overflow — A field with precision 5, scale 2 must round to an absolute value less than 10^3

A number doesn’t fit the column’s numeric(precision, scale) or integer range.

Exact message you may see numeric field overflowinteger out of range
Explore the map of this error Full error map →
Seen on: PostgreSQL

Meaning

numeric(5,2) allows up to 999.99. integer overflows above 2,147,483,647 (“integer out of range”).

Common causes

  • Value larger than precision allows
  • integer columns for large ids/counters
  • Currency in minor units exceeding int

⚡ Quick fix

  1. Increase precision (numeric(12,2))
  2. Use bigint for large ids/counters

Detailed fix by platform

PostgreSQL

  1. ALTER TABLE orders ALTER COLUMN total TYPE numeric(12,2);

How to diagnose

  1. Column — Type and precision
  2. Value — How large?

🔧 Still not fixed?

Many errors look alike. If the steps above didn’t solve it, one of these is probably what you’re facing:

Where this error sits

Origin: Data. Errors that are often confused with or caused by this one (click to open):

1264 — MySQL ERROR 1264 (22003): Out of range value for column 'x' at row 1 (MySQL)126422008 — ERROR: date/time field value out of range: "31/12/2024" — HINT: Perhaps you need a different "datestyle" setting. (PostgreSQL)2200822P02 — ERROR: invalid input syntax for type integer: "abc" (PostgreSQL)22P0222P02 uuid — ERROR: invalid input syntax for type uuid: "x" (PostgreSQL)22P02 uuid42804 — ERROR: column "x" is of type integer but expression is of type text — HINT: You will need to rewrite or cast the expression. (PostgreSQL)4280442883 operator — ERROR: operator does not exist: integer = text (PostgreSQL)42883 operator8115 — SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115) (SQL)8115invalid_type — API Error: Invalid type — expected integer, received string (API)invalid_type22003

Explore the map of this error Full error map →

🧠 Still stuck? Analyze your error

Paste the full message, response headers or stack trace — we'll detect the platform and point to the most likely cause.

💬 What worked for others

No tips yet — did something else fix this for you?

Share what worked for you

Tips are checked by an editor before they appear. Links are removed.