How to create Postgres index with "NULLS NOT DISTINCT"?

[armoona]

How would I create a Postgresql index with NULLS NOT DISTINCT option in gorm?

Tried it with gorm:"index:,option:NULLS NOT DISTINCT", but it didn't work.

See this if you need more context:
https://stackoverflow.com/questions/8289100/create-unique-constraint-with-null-columns

[a631807682]

currently not supported

[philip-madden]

Any plans to implement this?

[Ponywka]

Just use pointers to make this fields nullable at least it works in my case

type SomethingThird struct {
    ID                int64
    SomethingFirstID  *int64 `gorm:"index:,unique"`
    SomethingSecondID *int64 `gorm:"index:,unique"`
}

[wandering-tales]

Just use pointers to make this fields nullable at least it works in my case

type SomethingThird struct {
    ID                int64
    SomethingFirstID  *int64 `gorm:"index:,unique"`
    SomethingSecondID *int64 `gorm:"index:,unique"`
}

Did work or not?

[nikolai-momot-thirdfort]

index:,unique

It does not work when I tested it locally

[abbyssoul]

Thank you for raising this issue; I, too, have run into this exact problem.
Here is PR to enable the use of the option param for PG indexes: go-gorm/postgres#288
Note, if I understand the code correctly, the index will only be created if it doesn't exist. So, there is no migration for existing indexes. Thus, when the above PR is merged, it should be possible to specify option:NULLS NOT DISTINCT, but for it to take effect for an existing table, you'll need to delete the existing index first and run a migration.

[ankur-2dp]

Thanks @abbyssoul , it worked . I have used like :
gorm:"index:idx_unique_transafer_id,unique,option:NULLS NOT DISTINCT"