Re: Bug on version 12 ? - Mailing list pgsql-general

From Tom Lane
Subject Re: Bug on version 12 ?
Date
Msg-id 26166.1589567647@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bug on version 12 ?  (PegoraroF10 <marcos@f10.com.br>)
Responses Re: Bug on version 12 ?
List pgsql-general
PegoraroF10 <marcos@f10.com.br> writes:
> Ok Tom but then you cannot go back and forth, like this ...
> select to_timestamp(jsonb_build_object('mydate',
> current_timestamp)->>'mydate', 'YYYY-MM-DD HH24:MI:SS');

> works on 11.7 but not on 12.3.

The advice I gave you was to stop using to_timestamp altogether.
That would work fine on any Postgres version.

            regards, tom lane



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Bug on version 12 ?
Next
From: "Andreas 'ads' Scherbaum"
Date:
Subject: Re: Inherited an 18TB DB & need to backup