Fetch JSONB Value for UNIQUE Constraint
От | David E. Wheeler |
---|---|
Тема | Fetch JSONB Value for UNIQUE Constraint |
Дата | |
Msg-id | 47E3DF5A-EF5E-4FA9-9477-08CCCC37023C@justatheory.com обсуждение исходный текст |
Ответы |
Re: Fetch JSONB Value for UNIQUE Constraint
|
Список | pgsql-hackers |
Dear Hackers, Should this work? CREATE TABLE things ( user_id INTEGER NOT NULL, document JSONB NOT NULL, UNIQUE (user_id, document->>'name') ); ERROR: syntax error at or near "->>" LINE 4: UNIQUE (user_id, document->>’name') I tried adding parens, but that didn’t work, either: CREATE TABLE things ( user_id INTEGER NOT NULL, document JSONB NOT NULL, UNIQUE (user_id, (document->>'name')) ); ERROR: syntax error at or near "(" LINE 4: UNIQUE (user_id, (document->>'name')) It works fine to create a unique index, though: CREATE TABLE things ( user_id INTEGER NOT NULL, document JSONB NOT NULL ); CREATE UNIQUE INDEX ON things(user_id,(document->>'name')); So it’s a fine workaround, but maybe there’s something missing from the parsing of the CREATE TABLE statement? This is on9.6.1. Best, David
В списке pgsql-hackers по дате отправления: