Postgres Pro
Downloads
Home   >   mailing lists

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

From David Rowley
Subject Re: Overlapping values (?) in multi-column partitioned tables
Date
Msg-id CAApHDvpfrn-ddUYVXSOV1BvoF8npqyZxZts7Gsg6nNR=FJg4Lw@mail.gmail.com
Whole thread Raw
In response to Re: Overlapping values (?) in multi-column partitioned tables  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Overlapping values (?) in multi-column partitioned tables
List pgsql-general
Tree view 
On Wed, 11 Sept 2024 at 10:57, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> You should specify the upper bound as ('2023-12-31 23:59:59.999999', MAXVALUE).

Or maybe do multi-level partitioning.

(it seems strange to always have MINVALUE and MAXVALUE as the range.
I'm guessing that was just an example.)

David

pgsql-general by date:

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