agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Tom Lane <tgl@sss.pgh.pa.us>
To: Alexey M Boltenkov <padrebolt@yandex.ru>
Cc: Voillequin, Jean-Marc <Jean-Marc.Voillequin@moodys.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-sql@lists.postgresql.org <pgsql-sql@lists.postgresql.org>
Subject: Re: unique index with several columns
Date: Fri, 04 Mar 2022 13:32:05 -0500
Message-ID: <3966274.1646418725@sss.pgh.pa.us> (raw)
In-Reply-To: <6699c0e9-e358-1fc2-7ce4-7a24d4bc419e@yandex.ru>
References: <MN2PR20MB2735507A85A89B7279AB6A2CBE059@MN2PR20MB2735.namprd20.prod.outlook.com>
<CAKFQuwa4dELLaEdm2UsZK-LyRA08VYOYQZyxNs8zF25nYzgv3w@mail.gmail.com>
<MN2PR20MB2735EB2F5DA362B53277BE11BE059@MN2PR20MB2735.namprd20.prod.outlook.com>
<6699c0e9-e358-1fc2-7ce4-7a24d4bc419e@yandex.ru>
Alexey M Boltenkov <padrebolt@yandex.ru> writes:
> You need the new v15 feature:
> NULLS [NOT] DISTINCT
That won't replicate the behavior shown by the OP though.
In particular, not the weird inconsistency for all-null rows.
regards, tom lane
view thread (12+ messages) latest in thread
Message-ID: <3966274.1646418725@sss.pgh.pa.us>
Permalink: ../3966274.1646418725@sss.pgh.pa.us/
Also on: postgresql.org/message-id/3966274.1646418725@sss.pgh.pa.us
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, padrebolt@yandex.ru, Jean-Marc.Voillequin@moodys.com, david.g.johnston@gmail.com, pgsql-sql@lists.postgresql.org
Subject: Re: unique index with several columns
In-Reply-To: <3966274.1646418725@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox