Re: Unique index problem - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Unique index problem
Date
Msg-id CAOR=d=3EV73mdxvhQYJ1vx0_N_zA8r9noO2Hmy6tRz60A5--zw@mail.gmail.com
Whole thread Raw
In response to Re: Unique index problem  ("Sterpu Victor" <victor@caido.ro>)
Responses Re: Unique index problem  (John McKown <john.archie.mckown@gmail.com>)
List pgsql-general
On Sun, Dec 20, 2015 at 11:39 PM, Sterpu Victor <victor@caido.ro> wrote:
> Thank you.
>
> I used the syntax with 2 indexes, it works for me.
> But why does NULL != NULL?

Because NULL literally means "an unknown, possibly unknowable value."

You need to stop thinking of NULL as A value. It is not.


pgsql-general by date:

Previous
From: oleg yusim
Date:
Subject: Re: Session Identifiers
Next
From: John McKown
Date:
Subject: Re: Unique index problem