Idea - Unique index except null

Unique index except null

New

Database

Hi there,

My idea for the indexes is to have a provision in the unique indexes to allow duplicate null values. I have several cases (tables) where an attribute must be unique, if a value is provided. So the attribute is non-mandatory, but must be unique when provided. SQL Server allows it, Oracle must be as well.

Now i need to build logic each time i have a use case for this.

Saludos,

Wilko

02 Nov 2019

Márcio Mônego Fonseca

Hi Wilko,

I think that with the absence of null, except for reference columns(fks) you can't achieve this with Outsystems.

Let's see what the experts say to us.

04 Nov 2019

wilko odijk

Marcio hi,

It is especially for foreign keys where i have the use cases. I tried that with OS, but the second insert for the null foreign key triggers the unique validation. Now I have check it programmatically.

Saludos,

Wilko

04 Nov 2019

Magda Pereira

Changed the category to

Database

12 Nov 2019