Postgres Pro
Downloads
Home   >   mailing lists

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

From David E. Wheeler
Subject Re: Fetch JSONB Value for UNIQUE Constraint
Date
Msg-id C2F3D3B7-66F7-40D5-9B54-6BBAE6D697A4@justatheory.com
Whole thread Raw
In response to Re: Fetch JSONB Value for UNIQUE Constraint  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
Tree view 
On Mar 24, 2017, at 5:00 PM, Peter Geoghegan <pg@bowt.ie> 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).

Oh. Okay. I assumed the syntax would be identical to a unique index, since that’s ultimately what a unique constraint
is,IIUC. My mistake. 

Thanks Peter!

Best,

David

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: [PATCH] Transaction traceability - txid_status(bigint)
Next
From: Peter Geoghegan
Date:
Subject: Re: ICU integration