Subject: Re: Cast jsonb to numeric, int, float, bool
To: Jim Nasby <Jim.Nasby@BlueTreble.com>, a.lubennikova@postgrespro.ru
References: <0154d35a-24ae-f063-5273-9ffcdf1c7f2e@postgrespro.ru>
 <55137679-fd6b-baf0-bfbf-6558ce5cb409@postgrespro.ru>
 <6e36f08b-0fa5-445e-55bc-654b9afb7f04@BlueTreble.com>
Cc: PostgreSQL mailing lists <pgsql-hackers@postgresql.org>
From: Nikita Glukhov <n.gluhov@postgrespro.ru>
Organization: Postgres Professional
Message-ID: <8ad4288a-b6b4-d799-2887-c94e5c3c69f3@postgrespro.ru>
Date: Thu, 2 Feb 2017 02:02:17 +0300
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.7.0
MIME-Version: 1.0
In-Reply-To: <6e36f08b-0fa5-445e-55bc-654b9afb7f04@BlueTreble.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

On 02.02.2017 01:07, Jim Nasby wrote:
> On 2/1/17 8:26 AM, Nikita Glukhov wrote:
>> Some comments about the code: I think it would be better to
>>  * add function for extraction of scalars from pseudo-arrays
>>  * iterate until WJB_DONE to pfree iterator
>
> I'm not sure what your intent here is, but if the idea is that a json array
> would magically cast to a bool or a number data type I think that's a bad idea.

My idea, of course, is not about casting any json array to a scalar.  It is only
about helper subroutine for extraction of top-level jsonb scalars that are always
stored as one-element pseudo-arrays with special flag F_SCALAR in the array header.

-- 
Nikita Glukhov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


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