Rails active record unique constraints with field value on postgres

Question

Is it possible to create unique constraints on active record with value of field.

So this code will add a constraints of 2 columns:

add_index :my_table,[:field_1,:field_2],:unique => true

But I would like to have the same constrains where field_2 == true

For example something like this

add_index :my_table,[:field_1,:field_2 => true],:unique => true

Is it possible ? I saw that it is possible on postgres

Sebastián Palma · Accepted Answer · 2019-11-13 15:04:41Z

3

For partial indexes you can use the where option:

add_index :my_table, [:field_1, :field_2], unique: true, where: 'field_2 = true'
# "index_my_tables_on_field_1_and_field_2" UNIQUE, btree (field_1, field_2) WHERE field_2 = true

answered Nov 13, 2019 at 15:04

Sebastián Palma

33.6k6 gold badges45 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

Rails active record unique constraints with field value on postgres

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related