CODEWITHSUNDEEP
sqlpostgresql
Pooya Mohammadi Kazaj
Pooya Mohammadi Kazaj

Reputation: 153

How to set a limit for an array type field in postgresql

I want to define a PostgreSQL table like below:

create table contacts (
    first_name varchar,
    last_name varchar,
    phone_numbers varchar[]
);

However, I want to set a limit for phone_numbers so that the user cannot insert data more than that limit.

Upvotes: 0

Views: 49

Answers (1)

user330315
user330315

Reputation:

Use a check constraint:

create table contacts (
  first_name varchar,
  last_name varchar,
  phone_numbers varchar[],
  constraint limit_phone_numbers
     check (cardinality(phone_numbers) <= 5)
);

Upvotes: 4

Related Questions