On 19/05/2014 15:14, Knut Anders Hatlen wrote:
Hi John,I think CREATE UNIQUE INDEX ui ON Foo(A, B) might do what you want. In contrast to a unique constraint, a unique index doesn't allow duplicate nulls.
OK, many thanks! -- John English
On 19/05/2014 15:14, Knut Anders Hatlen wrote:
Hi John,I think CREATE UNIQUE INDEX ui ON Foo(A, B) might do what you want. In contrast to a unique constraint, a unique index doesn't allow duplicate nulls.
OK, many thanks! -- John English