If I want to create a table
create table users (
and a constraint unique(id,name) but the unique constraint should
only be used for the enabled users, how can I do that?
The only way I can think of is to use null values when a user is not
enabled and use the constraint unique(id,name,enable).
Are there other ways of doing this?
pgsql-novice by date
|Next:||From: Thomas Kellerer||Date: 2011-01-24 10:43:33|
|Subject: Re: Unique constraint on only some of the rows|
|Previous:||From: Sean Davis||Date: 2011-01-24 09:52:59|
|Subject: Re: Select and update with limit and locking|