Re: Unique index problem

From: John McKown <john(dot)archie(dot)mckown(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unique index problem
Date: 2015-12-21 19:07:01
Message-ID: CAAJSdjiCATyNgyyQEowPyxH6jiDu1rUGvK-ziSBwHcbqZoMFQA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Dec 21, 2015 at 1:00 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
wrote:

> On Sun, Dec 20, 2015 at 11:39 PM, Sterpu Victor <victor(at)caido(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2015-12-22 04:35:54 Re: BDR error while adding 3rd node to cluster
Previous Message Scott Marlowe 2015-12-21 19:00:28 Re: Unique index problem