pgsql: Preserve tz when converting to jsonb timestamptz

2024-07-30 Thread Andrew Dunstan
Preserve tz when converting to jsonb timestamptz This removes an inconsistency in the treatment of different datatypes by the jsonpath timestamp_tz() function. Conversions from data types that are not timestamp-aware, such as date and timestamp, are now treated consistently with conversion from th

pgsql: Preserve tz when converting to jsonb timestamptz

2024-07-30 Thread Andrew Dunstan
Preserve tz when converting to jsonb timestamptz This removes an inconsistency in the treatment of different datatypes by the jsonpath timestamp_tz() function. Conversions from data types that are not timestamp-aware, such as date and timestamp, are now treated consistently with conversion from th