On Sat, Feb 10, 2024 at 10:55 PM Andrew Dunstan wrote:
>
> On 2024-02-08 Th 21:02, Jeevan Chalke wrote:
>
>
>
> On Thu, Feb 8, 2024 at 2:22 PM jian he
> wrote:
>
>> On Thu, Feb 8, 2024 at 1:27 PM Jeevan Chalke
>> wrote:
>> >
>> >
>> >
>> > On Wed, Feb 7, 2024 at 9:13 PM jian he
>> wrote:
>>
On 2024-02-08 Th 21:02, Jeevan Chalke wrote:
On Thu, Feb 8, 2024 at 2:22 PM jian he
wrote:
On Thu, Feb 8, 2024 at 1:27 PM Jeevan Chalke
wrote:
>
>
>
> On Wed, Feb 7, 2024 at 9:13 PM jian he
wrote:
>>
>> On Wed, Feb 7, 2024 at 7:36 PM Jeevan Chalke
On Thu, Feb 8, 2024 at 2:22 PM jian he wrote:
> On Thu, Feb 8, 2024 at 1:27 PM Jeevan Chalke
> wrote:
> >
> >
> >
> > On Wed, Feb 7, 2024 at 9:13 PM jian he
> wrote:
> >>
> >> On Wed, Feb 7, 2024 at 7:36 PM Jeevan Chalke
> >> wrote:
> >> > Added checkTimezoneIsUsedForCast() check where ever
On Thu, Feb 8, 2024 at 1:27 PM Jeevan Chalke
wrote:
>
>
>
> On Wed, Feb 7, 2024 at 9:13 PM jian he wrote:
>>
>> On Wed, Feb 7, 2024 at 7:36 PM Jeevan Chalke
>> wrote:
>> > Added checkTimezoneIsUsedForCast() check where ever we are casting
>> > timezoned to non-timezoned types and vice-versa.
On Wed, Feb 7, 2024 at 9:13 PM jian he wrote:
> On Wed, Feb 7, 2024 at 7:36 PM Jeevan Chalke
> wrote:
> > Added checkTimezoneIsUsedForCast() check where ever we are casting
> timezoned to non-timezoned types and vice-versa.
>
> https://www.postgresql.org/docs/devel/functions-json.html
> above
On Wed, Feb 7, 2024 at 7:36 PM Jeevan Chalke
wrote:
> Added checkTimezoneIsUsedForCast() check where ever we are casting timezoned
> to non-timezoned types and vice-versa.
https://www.postgresql.org/docs/devel/functions-json.html
above Table 9.51. jsonpath Filter Expression Elements, the Note
On Tue, Feb 6, 2024 at 5:25 PM Andrew Dunstan wrote:
>
> On 2024-02-05 Mo 22:06, jian he wrote:
>
>
> Hi.
> this commit [0] changes immutability of jsonb_path_query,
> jsonb_path_query_first?
> If so, it may change other functions also.
>
>
Thanks for reporting Jian.
Added
On 2024-02-05 Mo 22:06, jian he wrote:
Hi.
this commit [0] changes immutability of jsonb_path_query,
jsonb_path_query_first? If so, it may change other functions also.
demo:
begin;
SET LOCAL TIME ZONE 10.5;
with cte(s) as (select jsonb '"2023-08-15 12:34:56 +05:30"')
select
Hi.
this commit [0] changes immutability of jsonb_path_query,
jsonb_path_query_first?
If so, it may change other functions also.
demo:
begin;
SET LOCAL TIME ZONE 10.5;
with cte(s) as (select jsonb '"2023-08-15 12:34:56 +05:30"')
select jsonb_path_query(s,