Обсуждение: No multi range functions on version 12

Поиск
Список
Период
Сортировка

No multi range functions on version 12

От
PG Doc comments form
Дата:
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.

Re: No multi range functions on version 12

От
Magnus Hagander
Дата:
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...

--

Re: No multi range functions on version 12

От
"Jonathan S. Katz"
Дата:
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/

Вложения

Re: No multi range functions on version 12

От
Nimrod Sadeh
Дата:
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/

Вложения