> On 10/07/2023 04:25 CEST pf@xxxxxxxxxxx wrote: > > 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! Also keep in mind that it's not trivial to model addresses, even in a single country. Some database constraints may become a footgun. https://www.mjt.me.uk/posts/falsehoods-programmers-believe-about-addresses/ -- Erik
