On Sep 29, 2008, at 4:59 AM, Chris wrote:
Matthew Wilson wrote:
I'm trying to comprehend how NULL values interact with unique
indexes.
It seems like I can insert two rows with NULL values in a column
with a
unique constraint just fine.
Is there something special about NULL? Can anyone post
You can always add a constraint that these columns cannot be NULL
themselves. That removes this problem.
On Sep 28, 2008, at 11:17 PM, Klint Gore <[EMAIL PROTECTED]> wrote:
Matthew Wilson wrote:
I'm trying to comprehend how NULL values interact with unique
indexes.
It seems like I can inser
Matthew Wilson wrote:
I'm trying to comprehend how NULL values interact with unique indexes.
It seems like I can insert two rows with NULL values in a column with a
unique constraint just fine.
Is there something special about NULL? Can anyone post some links to
explain what is going on?
h
Matthew Wilson <[EMAIL PROTECTED]> writes:
> It seems like I can insert two rows with NULL values in a column with a
> unique constraint just fine.
This is per SQL spec and quite well-documented in our manual ...
regards, tom lane
--
Sent via pgsql-general mailing list (
Matthew Wilson wrote:
I'm trying to comprehend how NULL values interact with unique indexes.
It seems like I can insert two rows with NULL values in a column with a
unique constraint just fine.
Is there something special about NULL? Can anyone post some links to
explain what is going on?
When
