Re: pgsql: Add casts from jsonb

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: pgsql: Add casts from jsonb
Дата
Msg-id 425d73d0-7176-2287-3d40-9c2e8bb94541@sigaev.ru
обсуждение исходный текст
Ответ на pgsql: Add casts from jsonb  (Teodor Sigaev <teodor@sigaev.ru>)
Ответы Re: pgsql: Add casts from jsonb  (Teodor Sigaev <teodor@sigaev.ru>)
Список 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@postgrespro.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@sigaev.ru
                                                    WWW: http://www.sigaev.ru/


В списке pgsql-committers по дате отправления:

Предыдущее
От: Teodor Sigaev
Дата:
Сообщение: pgsql: Add casts from jsonb
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: pgsql: Optimize btree insertions for common case of increasing values