> On 10/07/2023 04:25 CEST p...@pfortin.com wrote:
>
> On Sun, 9 Jul 2023 17:04:03 -0700 Adrian Klaver wrote:
>
> >On 7/9/23 15:58, p...@pfortin.com wrote:
> >> Hi,
> >>
> >> Trying to figure out how to insert new property addresses into an
> >> existing table.
> >>
> >> Can a UNIQUE constraint be
On Sun, 9 Jul 2023 16:42:15 -0700 David G. Johnston wrote:
>Yes, the mechanics of defining multi-column unique constraints on tables is
>covered in the docs.
Good to know I'm not searching in vain...
On Sun, 9 Jul 2023 17:04:03 -0700 Adrian Klaver wrote:
>On 7/9/23 15:58, p...@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
On 7/9/23 17:04, Adrian Klaver wrote:
On 7/9/23 15:58, p...@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
On 7/9/23 15:58, p...@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
*
On Sun, Jul 9, 2023 at 3:58 PM 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
A UNIQUE index can have any number of columns, so you can create an index with
all of the appropriate columns listed. This is different from having a UNIQUE
index on each individual column. In the former case, all of the columns
together must be unique; in the latter case, as you mention,
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