INSERT UNIQUE row?

Поиск
Список
Период
Сортировка
От pf@pfortin.com
Тема INSERT UNIQUE row?
Дата
Msg-id 20230709185807.1bc9afd9.pfortin@pfortin.com
обсуждение исходный текст
Ответы Re: INSERT UNIQUE row?
Re: INSERT UNIQUE row?
Re: INSERT UNIQUE row?
Список 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?