PostgreSQL 8.4 : 2009 release of PostgreSQL

learn more… | top users | synonyms (1)

5
votes
2answers
535 views

Custom unique column constraint, only enforced if one column has a specific value

Is it possible to have a custom unique column constraint as follows? Suppose I have two cols, subset and type, both strings (though the data types probably doesn't matter). If type is "true", then ...