On 5/15/20 12:35 PM, PegoraroF10 wrote:
> I understood, but the problem is that I cannot just migrate from 11 to 12, I
> have to carefully verify all code before migration.
It would be helpful to include the information you are responding to.
The simplest case works on 11:
select version();
version
---------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 11.8 (Ubuntu 11.8-1.pgdg18.04+1) on x86_64-pc-linux-gnu,
compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit
select (jsonb_build_object('mydate',
test(# current_timestamp)->>'mydate')::timestamptz;
timestamptz
-------------------------------
2020-05-15 12:55:26.259151-07
(1 row)
>
>
>
> --
> Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com