Postgres Pro
Downloads
Home   >   mailing lists

BUG #13506: jsonb || operator does not work - Mailing list pgsql-bugs

From gregoire.hubert@pragmafabrik.com
Subject BUG #13506: jsonb || operator does not work
Date
Msg-id 20150720155838.9706.10338@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13506: jsonb || operator does not work  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      13506
Logged by:          Grégoire HUBERT
Email address:      gregoire.hubert@pragmafabrik.com
PostgreSQL version: 9.5alpha1
Operating system:   debian jessie
Description:

select val->'a'||val->'c' from (values ($j${"a": {"b": 2}, "c": {"d":
3}}$j$::jsonb)) a (val);
┌──────────┐
│ ?column? │
├──────────┤
│ {"d": 3} │
└──────────┘
(1 row)

I think this should return '{"b": 2, "d": 3}'

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] object_classes array is broken, again
Next
From: Tom Lane
Date:
Subject: Re: BUG #13506: jsonb || operator does not work