Numeric value out of range

Common SQL Errors

Runtime

Sign up for the latest in common SQL errors from the Galaxy Team!

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Overflow (e.g., inserting 1000000 into a SMALLINT)

PostgreSQL

Numeric value out of range

Explanation

This error arises when a numeric value exceeds the allowed range for its data type. Use a larger type like BIGINT.

Common Causes

Exceeding SMALLINT or INT limits

Related Errors

FAQs

Check out some other errors

Division by zero

Datatype mismatch

Duplicate column

Trusted by top engineers on high-velocity teams

Assort Health

Curri

Rubie

Comulate