Re: jsonb_each_text(jsonb) returns value::jsonb, not text

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: vodevsh(at)gmail(dot)com, pgsql-docs(at)postgresql(dot)org
Subject: Re: jsonb_each_text(jsonb) returns value::jsonb, not text
Date: 2016-12-11 13:36:29
Message-ID: 900a67c4-762b-5386-86b4-a9537c40bc72@joh.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On 2016-12-09 2:05 PM, vodevsh(at)gmail(dot)com wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/9.6/static/functions-json.html
> Description:
>
> Hi,
> According to
> https://www.postgresql.org/docs/current/static/functions-json.html,
> &quot;jsonb_each_text(jsonb)&quot; returns &quot;setof key text, value text&quot;, but if you
> &quot;pg_typeof(value)&quot; on result it shows &quot;jsonb&quot;.

Not here:

=> select pg_typeof(value) from jsonb_each_text('{"foo":"bar"}');
pg_typeof
-----------
text
(1 row)

.m

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message penorman 2016-12-12 00:04:29 pg_dump multiple CPUs
Previous Message vodevsh 2016-12-09 13:05:49 jsonb_each_text(jsonb) returns value::jsonb, not text