Subject: Re: jsonb_each_text(jsonb) returns value::jsonb, not text
To: vodevsh@gmail.com, pgsql-docs@postgresql.org
References: <20161209130549.1402.15836@wrigleys.postgresql.org>
From: Marko Tiikkaja <marko@joh.to>
Message-ID: <900a67c4-762b-5386-86b4-a9537c40bc72@joh.to>
Date: Sun, 11 Dec 2016 14:36:29 +0100
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101
 Thunderbird/45.5.1
MIME-Version: 1.0
In-Reply-To: <20161209130549.1402.15836@wrigleys.postgresql.org>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

On 2016-12-09 2:05 PM, vodevsh@gmail.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


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs