Re: Overlapping values (?) in multi-column partitioned tables

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Overlapping values (?) in multi-column partitioned tables
Date: 2024-09-10 23:05:47
Message-ID: 7A1E70B8-D213-4A5D-88AD-8AD634A10576@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Sep 10, 2024, at 15:57, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2024-09-10 23:05:54 Re: Overlapping values (?) in multi-column partitioned tables
Previous Message David Rowley 2024-09-10 23:02:11 Re: Overlapping values (?) in multi-column partitioned tables