PostgreSQL- How to validate two fields values ocorrence

Question

I have a table that contains the name and date columns. I want to block the insertion of a repeated combination. For example, if I have a record with {name: "joe", date: "2021-05-24"} I need to not allow the insertion of another record {name: "joe", date: "2021-05-24"}. Do exists a simple way to do this in PosgresSQL?

Initially I thought of a dynamic concatenator that would create a string for a column that would be responsible for this validation but I imagine that there is something more elegant.

So you want to allow joes with other dates? And other people on the same date? — Bergi
– Bergi, Commented May 24, 2021 at 12:39

2 revs · Accepted Answer · 2021-05-24 13:04:23Z

1

You're looking for a multi-column UNIQUE index (or primary key, which uses the same thing underneath). No need for concatenation.

Collectives™ on Stack Overflow

PostgreSQL- How to validate two fields values ocorrence

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related