Re: Unique index problem

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Sterpu Victor <victor(at)caido(dot)ro>
Cc: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>, Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
Subject: Re: Unique index problem
Date: 2015-12-21 19:00:28
Message-ID: CAOR=d=3EV73mdxvhQYJ1vx0_N_zA8r9noO2Hmy6tRz60A5--zw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John McKown 2015-12-21 19:07:01 Re: Unique index problem
Previous Message oleg yusim 2015-12-21 16:58:56 Re: Session Identifiers