multirange of arrays not working on postgresql 14

From: Jian He <hejian(dot)mark(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: multirange of arrays not working on postgresql 14
Date: 2022-04-23 06:26:55
Message-ID: CAMV54g1oeU2+Wf9gniN83GMPD9f08dqUz1b_ypJJ0N3+x7+W_g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

select arraymultirange(arrayrange(array[1,2], array[2,1]));

ERROR: 42883: function arrayrange(integer[], integer[]) does not exist
> LINE 1: select arraymultirange(arrayrange(array[1,2], array[2,1]));
> ^
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
> LOCATION: ParseFuncOrColumn, parse_func.c:629

tested on postgresql 14.
git.postgresql.org Git - postgresql.git/blob -
src/test/regress/sql/multirangetypes.sql
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/sql/multirangetypes.sql;h=9be26f10d381f4af61a48f55606a80e49706b959;hb=6df7a9698bb036610c1e8c6d375e1be38cb26d5f>
line:590
to 600.
git.postgresql.org Git - postgresql.git/blob -
src/test/regress/expected/multirangetypes.out
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/expected/multirangetypes.out;h=ac2eb84c3af90db38a14609749a5607653d0b26e;hb=7ae1619bc5b1794938c7387a766b8cae34e38d8a#l2849>
line
3200 to line 3210

I search log: git.postgresql.org Git - postgresql.git/log
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=log;h=6df7a9698bb036610c1e8c6d375e1be38cb26d5f>
there
is no mention of arrayrange. So this feature is available, but now seems
not working?
db fiddle: Postgres 14 | db<>fiddle (dbfiddle.uk)
<https://dbfiddle.uk/?rdbms=postgres_14&fiddle=b3cb2a726ff5cedbf8aa05e11c5287e4>

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bharath Rupireddy 2022-04-23 06:59:25 Re: Throttling WAL inserts when the standby falls behind more than the configured replica_lag_in_bytes
Previous Message Greg Stark 2022-04-23 06:18:01 Re: Implementing Incremental View Maintenance