UNIQUE for combined keys

[TPausL]

How would I create an index which ensures that the combination of 2 keys is unique?
DEFINE INDEX test_index ON TABLE test COLUMNS prop_one,prop_two UNIQUE; ensures that prop_one and prop_two are unique on their own so you can't create records like
prop_one = hello, prop_two = bye
prop_one = hello, prop_two = hello
i would like to be able to create those two but not two of the same

[tobiemh]

Hi @TPausL in order to do what you want, you would need to add a separate UNIQUE index for each key!

[TPausL]

With two separate unique keys I can't create two records that have one property in common. That should be possible. I just want the combination of two keys to be unique not every one on its own.

[szabgab]

As far as I can tell this already works in version 2.0