From: Nimrod Sadeh <nnnsadeh@gmail.com>
To: Jonathan S. Katz <jkatz@postgresql.org>
Cc: Magnus Hagander <magnus@hagander.net>
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: No multi range functions on version 12
Date: Thu, 15 Dec 2022 09:40:34 -0500
Message-ID: <92F3B56C-4B48-4217-8166-6CD429BBB339@gmail.com> (raw)
In-Reply-To: <767db42b-e2a7-2685-c25d-4479de3c8422@postgresql.org>
References: <167104405233.1903.9825435050311913338@wrigleys.postgresql.org>
<CABUevEwF3jQ=jNANSR7qr82ai1zRLNDgkW1-cw=VtXYRxHWxFA@mail.gmail.com>
<767db42b-e2a7-2685-c25d-4479de3c8422@postgresql.org>
I misread the “supported versions” section of the documentation, being new to Postgres. In the following screenshot, I took it to mean that this feature (ranges/multiranges) is supported for the “supported version” as opposed to the platform as a whole:
> On Dec 15, 2022, at 9:00 AM, Jonathan S. Katz <jkatz@postgresql.org> wrote:
>
> On 12/15/22 6:46 AM, Magnus Hagander wrote:
>> On Thu, Dec 15, 2022 at 12:45 PM PG Doc comments form <noreply@postgresql.org <mailto:noreply@postgresql.org>> wrote:
>> The following documentation comment has been logged on the website:
>> Page: https://www.postgresql.org/docs/15/rangetypes.html
>> <https://www.postgresql.org/docs/15/rangetypes.html;
>> Description:
>> Hello, according to the documentation, Postgres 12 should have multi
>> range
>> functions. However, in my installation of Postgres 12.12, I don't
>> have any
>> multi range function. When I ran them Postgres said they didn't
>> exist and I
>> can't see them when querying through pg_proc.
>> What documentation says they should be in version 12? The page you commented on is about PostgreSQL 15, and multiranges were not present in version 12...
>
> Multiranges were added in PostgreSQL 14:
>
> "Range types have been extended by adding multiranges, allowing representation of noncontiguous data ranges."[1]
>
> Jonathan
>
> [1] https://www.postgresql.org/docs/release/14.0/Attachments:
[image/png] Screen Shot 2022-12-15 at 9.38.59 AM.png (75.3K, ../92F3B56C-4B48-4217-8166-6CD429BBB339@gmail.com/3-Screen%20Shot%202022-12-15%20at%209.38.59%20AM.png)
download | view image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: nnnsadeh@gmail.com, jkatz@postgresql.org, magnus@hagander.net, pgsql-docs@lists.postgresql.org
Subject: Re: No multi range functions on version 12
In-Reply-To: <92F3B56C-4B48-4217-8166-6CD429BBB339@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox