On Sun, 9 Jul 2023 17:04:03 -0700 Adrian Klaver wrote: >On 7/9/23 15:58, pf@xxxxxxxxxxx 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 Thanks! Just getting started on this issue and this made me realize my current data source may not be the best... Much appreciated! >> >> Each row is only unique as an entity; but the columns are not... >> >> Is this covered in the docs? >> >> Thanks, >> Pierre >> >> >> >
