Re: pgsql: Add casts from jsonb

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: Re: pgsql: Add casts from jsonb
Date: 2018-03-29 14:57:25
Message-ID: 425d73d0-7176-2287-3d40-9c2e8bb94541@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Seems, I broke Windows again, it doesn't like this patch, see
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=whelk&dt=2018-03-29%2013%3A41%3A13

But I don't understand how it could be...

Teodor Sigaev wrote:
> Add casts from jsonb
>
> Add explicit cast from scalar jsonb to all numeric and bool types. It would be
> better to have cast from scalar jsonb to text too but there is already a cast
> from jsonb to text as just text representation of json. There is no way to have
> two different casts for the same type's pair.
>
> Bump catalog version
>
> Author: Anastasia Lubennikova with editorization by Nikita Glukhov and me
> Review by: Aleksander Alekseev, Nikita Glukhov, Darafei Praliaskouski
> Discussion: https://www.postgresql.org/message-id/flat/0154d35a-24ae-f063-5273-9ffcdf1c7f2e(at)postgrespro(dot)ru
>
> Branch
> ------
> master
>
> Details
> -------
> https://git.postgresql.org/pg/commitdiff/c0cbe00fee6d0a5e0ec72c6d68a035e674edc4cc
>
> Modified Files
> --------------
> src/backend/utils/adt/jsonb.c | 175 ++++++++++++++++++++++++++++++++++++
> src/include/catalog/catversion.h | 2 +-
> src/include/catalog/pg_cast.h | 9 ++
> src/include/catalog/pg_proc.h | 16 ++++
> src/test/regress/expected/jsonb.out | 105 ++++++++++++++++++++++
> src/test/regress/sql/jsonb.sql | 22 +++++
> 6 files changed, 328 insertions(+), 1 deletion(-)
>

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Simon Riggs 2018-03-29 14:59:45 Re: pgsql: Optimize btree insertions for common case of increasing values
Previous Message Stephen Frost 2018-03-29 13:51:10 Re: pgsql: Add documentation for the JIT feature.