Postgres Pro
Downloads
Home   >   mailing lists

jsonb_array_elements issue - Mailing list pgsql-bugs

From mephysto
Subject jsonb_array_elements issue
Date
Msg-id 1470404352397-5915026.post@n5.nabble.com
Whole thread Raw
Responses Re: jsonb_array_elements issue  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view 
Hi there,
I found an issue in jsonb_array_elements that can be a bug. I am using
PostgreSQL 9.5.3.

With this JSON:




If I try to execute



I get this error: ERROR:  unknown type of jsonb container


Instead, If I use json_array_elements with the same argument, I get no
errors:



return this result:



Moreover it is strange that jsob function run without errors if I execute it
with internal JSON as parameter:



returns correct JSON.


Is it an error genrate by myself or is it a bug indeed?

Thanks in advance.

Meph



--
View this message in context: http://postgresql.nabble.com/jsonb-array-elements-issue-tp5915026.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

pgsql-bugs by date:

Previous
From: c.to@vmm.be
Date:
Subject: BUG #14281: Postgres service won't start up anymore
Next
From: "David G. Johnston"
Date:
Subject: Re: jsonb_array_elements issue