INSERT UNIQUE row?

Поиск
Список
Период
Сортировка
От pf@pfortin.com
Тема INSERT UNIQUE row?
Дата
Msg-id 20230709185807.1bc9afd9.pfortin@pfortin.com
обсуждение исходный текст
Ответы Re: INSERT UNIQUE row?  (Christophe Pettus <xof@thebuild.com>)
Re: INSERT UNIQUE row?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: INSERT UNIQUE row?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hi,

Trying to figure out how to insert new property addresses into an
existing table.

Can a UNIQUE constraint be applied to an entire row?  Adding UNIQUE to
each column won't work in such a case since there are multiple properties
* on the same street
* in the same town
* with the same number on different streets
* etc...

Each row is only unique as an entity; but the columns are not...  

Is this covered in the docs?

Thanks,
Pierre




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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: How to add function schema in search_path in option definitio
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: INSERT UNIQUE row?