Postgres - how to enforce NUMERIC value between 1 & 10

Question

In PostgreSQL I have a column city_rate value NUMERIC DEFAULT 1.00.

Is there a way from postgres to enforce that value to be between two values: 1.00 & 10.00.

Like if user INSERT or UPDATE city_rate with a value greater than 10.00 it will save it as 10.00, or if the value is lower than 1.00 it will be saved as 1.00.

Tim Biegeleisen · Accepted Answer · 2022-02-22 09:06:51Z

3

You could use a check constraint:

ALTER TABLE yourTable
ADD CONSTRAINT rate_check CHECK (city_rate >= 1.0 AND city_rate <= 10.00);

answered Feb 22, 2022 at 9:06

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

David Namenyi Over a year ago

A tiny simplification idea: ADD CONSTRAINT rate_check CHECK (city_rate BETWEEN 1 AND 10)

Collectives™ on Stack Overflow

Postgres - how to enforce NUMERIC value between 1 & 10

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related