On Fri, Dec 30, 2005 at 13:30:40 -0800,
CSN <cool_screen_name90001(at)yahoo(dot)com> wrote:
> I have three columns, and one of them can be null. I'd
> like to create a unique constraint across all three
> columns and allow only one null value. e.g.
> abc|123|null # not allowed
> def|456|null # not allowed
> Currently, the 'not allowed' lines are allowed.
That is how 'unique' constraints are supposed to work. One possible
solution is to use some normal value instead of 'NULL' to represent
In response to
pgsql-general by date
|Next:||From: Ubence Quevedo||Date: 2005-12-30 21:53:55|
|Subject: Correct way to set up Variables [Was - Simple Accumulating Number Loop?]|
|Previous:||From: CSN||Date: 2005-12-30 21:40:55|
|Subject: Re: unique constraint with a null column?|