"michael" <miblogic(at)yahoo(dot)com> writes:
> with regards to unique rows, i think we should deviate from the sql
That's not happening.
> or if this isn't possible, we should at least document this in
> postgresql's unique index/unique constraint's gotchas, make more obvious.
It is documented ... you just quoted the docs.
> i'm really surprised that two rows with equal values is allowed
It is not the case that "NULL = NULL", so why would you think that the
two rows are equal?
You probably need to rethink what you are using NULL for in this table.
It's really only good for cases where you mean to indicate that a value
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: jeffrey zhao||Date: 2007-05-14 16:02:42|
|Subject: BUG #3278: PSQLException when using setBinaryStream via JDBC|
|Previous:||From: Laurent FAILLIE||Date: 2007-05-14 12:00:29|
|Subject: RE : Re: BUG #3271: PREPARE/EXCUTE don't work|