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
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 |