No multi range functions on version 12
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.
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/>
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]https://www.postgresql.org/docs/release/14.0/
Jonathan
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:
Show quoted text
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