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>
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 |