Re: pgsql: Additional functions and operators for jsonb - Mailing list pgsql-committers

From Andrew Dunstan
Subject Re: pgsql: Additional functions and operators for jsonb
Date
Msg-id 5552666F.20409@dunslane.net
Whole thread Raw
In response to Re: pgsql: Additional functions and operators for jsonb  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-committers
On 05/12/2015 04:11 PM, Pavel Stehule wrote:
> Hi
>
> I did some tests, and I am not sure if this is not bug:
>
> postgres=# select '{"x":20}'::jsonb - 'x'::text;
> ERROR:  unknown type of jsonb container --->>> it should be empty
> jsonb, not error
> Time: 0.971 ms
> postgres=# select '{"x":20, "y":30}'::jsonb - 'x'::text;
> ┌───────────┐
> │ ?column?  │
> ╞═══════════╡
> │ {"y": 30} │
> └───────────┘
> (1 row)
>
>
> Regards
>
> Pavel
>

Yes. that's a bug.

will check.

cheers

andrew


pgsql-committers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: pgsql: Additional functions and operators for jsonb
Next
From: Andrew Dunstan
Date:
Subject: pgsql: Fix some errors from jsonb functions patch.