Re: Overlapping values (?) in multi-column partitioned tables - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Overlapping values (?) in multi-column partitioned tables
Date
Msg-id 7A1E70B8-D213-4A5D-88AD-8AD634A10576@thebuild.com
Whole thread Raw
In response to Re: Overlapping values (?) in multi-column partitioned tables  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general

> On Sep 10, 2024, at 15:57, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> So the upper limit of the first partition is strictly bigger than the lower end
> of the second partition.
>
> "record" types have the same lexicographical sorting order as ORDER BY clauses.

Ah, OK, got it.  I was thinking of them as a points on a plane, which was misleading.  Thanks!


pgsql-general by date:

Previous
From: David Rowley
Date:
Subject: Re: Overlapping values (?) in multi-column partitioned tables
Next
From: Christophe Pettus
Date:
Subject: Re: Overlapping values (?) in multi-column partitioned tables