Re: pgsql: Implement jsonpath .datetime() method - Mailing list pgsql-committers

From Tom Lane
Subject Re: pgsql: Implement jsonpath .datetime() method
Date
Msg-id 31235.1570933467@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql: Implement jsonpath .datetime() method  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Responses Re: pgsql: Implement jsonpath .datetime() method  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Re: pgsql: Implement jsonpath .datetime() method  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
List pgsql-committers
Alexander Korotkov <a.korotkov@postgrespro.ru> writes:
> This patch also changes the way timestamp to timestamptz cast works.
> Previously it did timestamp2tm() then tm2timestamp().  Instead, after
> timestamp2tm() it calculates timezone offset and applies it to
> original timestamp value.  I hope this is correct.

I'd wonder whether this gives the same answers near DST transitions,
where it's not real clear which offset applies.

Please *don't* wrap this sort of thing into an unrelated feature patch.

            regards, tom lane



pgsql-committers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: pgsql: Implement jsonpath .datetime() method
Next
From: Michael Paquier
Date:
Subject: pgsql: Fix dependency handling of column drop with partitioned tables