Re: jsonb unique constraints

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: jsonb unique constraints
Дата
Msg-id CAKFQuwZU_JYNV6MrwZfi6=RqEHkwKtx6MPb2nqVSr-_22QMSjQ@mail.gmail.com
обсуждение исходный текст
Ответ на jsonb unique constraints  (Ted Toth <txtoth@gmail.com>)
Ответы Re: jsonb unique constraints
Список pgsql-general
On Tue, May 5, 2020 at 8:33 AM Ted Toth <txtoth@gmail.com> wrote:
Can you have unique constraints on jsonb columns keys? I've looked for examples but haven't found any what is the proper syntax? Here's what I tried:

CREATE TABLE report_json (
    recnum int,
    id integer,
    report jsonb,
    PRIMARY KEY (recnum),
    CONSTRAINT report_json_unique_constraint UNIQUE (id,((report ->> 'data')::int),((report ->> 'ctc')::int),((report ->> 'dtg')::int)
);

which causes a syntax error at the first '(' around 'report ->>'.

Documentation says constraints must reference column names - so no.  You can probably get what you are after by directly creating a unique index though - those allow expressions.

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Installing Postgis25_11
Следующее
От: Clifford Snow
Дата:
Сообщение: Re: Installing Postgis25_11