pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedNo multi range functions on version 12
4+ messages / 4 participants
[nested] [flat]
* No multi range functions on version 12
@ 2022-12-14 18:54 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 4+ messages in thread
From: PG Doc comments form @ 2022-12-14 18:54 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: nnnsadeh@gmail.com
The following documentation comment has been logged on the website:
Page: 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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: No multi range functions on version 12
@ 2022-12-15 11:46 Magnus Hagander <magnus@hagander.net>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 4+ messages in thread
From: Magnus Hagander @ 2022-12-15 11:46 UTC (permalink / raw)
To: nnnsadeh@gmail.com; pgsql-docs@lists.postgresql.org
On Thu, Dec 15, 2022 at 12:45 PM PG Doc comments form <
noreply@postgresql.org> wrote:
> The following documentation comment has been logged on the website:
>
> Page: 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...
--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/;
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/;
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: No multi range functions on version 12
@ 2022-12-15 14:00 Jonathan S. Katz <jkatz@postgresql.org>
parent: Magnus Hagander <magnus@hagander.net>
0 siblings, 1 reply; 4+ messages in thread
From: Jonathan S. Katz @ 2022-12-15 14:00 UTC (permalink / raw)
To: Magnus Hagander <magnus@hagander.net>; nnnsadeh@gmail.com; pgsql-docs@lists.postgresql.org
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:
[application/pgp-signature] OpenPGP_signature (839B, ../../767db42b-e2a7-2685-c25d-4479de3c8422@postgresql.org/2-OpenPGP_signature)
download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: No multi range functions on version 12
@ 2022-12-15 14:40 Nimrod Sadeh <nnnsadeh@gmail.com>
parent: Jonathan S. Katz <jkatz@postgresql.org>
0 siblings, 0 replies; 4+ messages in thread
From: Nimrod Sadeh @ 2022-12-15 14:40 UTC (permalink / raw)
To: Jonathan S. Katz <jkatz@postgresql.org>; +Cc: Magnus Hagander <magnus@hagander.net>; pgsql-docs@lists.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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2022-12-15 14:40 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-12-14 18:54 No multi range functions on version 12 PG Doc comments form <noreply@postgresql.org>
2022-12-15 11:46 ` Magnus Hagander <magnus@hagander.net>
2022-12-15 14:00 ` Jonathan S. Katz <jkatz@postgresql.org>
2022-12-15 14:40 ` Nimrod Sadeh <nnnsadeh@gmail.com>
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