Re: Unique index problem - Mailing list pgsql-general

From John McKown
Subject Re: Unique index problem
Date
Msg-id CAAJSdjiCATyNgyyQEowPyxH6jiDu1rUGvK-ziSBwHcbqZoMFQA@mail.gmail.com
Whole thread Raw
In response to Re: Unique index problem  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
On Mon, Dec 21, 2015 at 1:00 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
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.

​Right. It would be sort of like asking: "is an object which I can't see the same as (==) or different from (!=) some other object which I can't see?" Answer: "How would I know???"​

 

--
Computer Science is the only discipline in which we view adding a new wing to a building as being maintenance -- Jim Horning

Schrodinger's backup: The condition of any backup is unknown until a restore is attempted.

Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.

He's about as useful as a wax frying pan.

10 to the 12th power microphones = 1 Megaphone

Maranatha! <><
John McKown

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Unique index problem
Next
From: Craig Ringer
Date:
Subject: Re: BDR error while adding 3rd node to cluster