Postgres Pro
Downloads
Home   >   mailing lists

Re: Fetch JSONB Value for UNIQUE Constraint - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Fetch JSONB Value for UNIQUE Constraint
Date
Msg-id CAH2-Wz=7Cxe5GwwXbZ1JdcfmQPGFNQvHcfGwam2jD3VBOM3X6A@mail.gmail.com
Whole thread Raw
In response to Fetch JSONB Value for UNIQUE Constraint  ("David E. Wheeler" <david@justatheory.com>)
Responses Re: Fetch JSONB Value for UNIQUE Constraint  ("David E. Wheeler" <david@justatheory.com>)
List pgsql-hackers
Tree view 
On Fri, Mar 24, 2017 at 4:57 PM, David E. Wheeler <david@justatheory.com> wrote:
> So it’s a fine workaround, but maybe there’s something missing from the parsing of the CREATE TABLE statement? This
ison 9.6.1. 

Unique constraints don't support expressions, or a predicate (partial-ness).


--
Peter Geoghegan

pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Fetch JSONB Value for UNIQUE Constraint
Next
From: Craig Ringer
Date:
Subject: Re: [PATCH] Transaction traceability - txid_status(bigint)