Re: INSERT UNIQUE row?
| От | Adrian Klaver |
|---|---|
| Тема | Re: INSERT UNIQUE row? |
| Дата | |
| Msg-id | fddb0c02-27cd-4f4b-2c28-45406499dad8@aklaver.com обсуждение исходный текст |
| Ответ на | Re: INSERT UNIQUE row? (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Список | pgsql-general |
On 7/9/23 17:04, Adrian Klaver wrote: > On 7/9/23 15:58, pf@pfortin.com wrote: >> 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... > > Does the locality you are in have something like the Property ID# and/or > Parcel # / Geo ID shown here: > > https://property.whatcomcounty.us/propertyaccess/PropertySearch.aspx?cid=0 Should have added, can you create your own surrogate PK to fill the same role? > >> >> Each row is only unique as an entity; but the columns are not... >> >> Is this covered in the docs? >> >> Thanks, >> Pierre >> >> >> > -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: