Re: Cast jsonb to numeric, int, float, bool
Aleksander Alekseev <a.alekseev@postgrespro.ru>
From: Aleksander Alekseev <a.alekseev@postgrespro.ru>
To: Teodor Sigaev <teodor@sigaev.ru>
Cc: Robert Haas <robertmhaas@gmail.com>, David Steele <david@pgmasters.net>, Nikita Glukhov <n.gluhov@postgrespro.ru>, Darafei Praliaskouski <me@komzpa.net>, Anastasia Lubennikova <a.lubennikova@postgrespro.ru>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2018-03-30T14:21:20Z
Lists: pgsql-hackers
Hello Teodor, > For completeness it's possible to add direct cast from numeric/boolean types > to jsonb. Then such casts will be mutual. +1. I see no reason why we can't have int4 -> jsonb or bool -> jsonb casts. > Agree, something like "could not convert jsonb value to boolean type. jsonb > value must be scalar boolean type"? I checked what error messages are used currently: ``` # select 123::int4::jsonb; ERROR: cannot cast type integer to jsonb LINE 1: select 123::int4::jsonb; ``` I suggest to follow the same template, i.e. "cannot cast type jsonb to bool", etc. -- Best regards, Aleksander Alekseev
Commits
-
Add casts from jsonb
- c0cbe00fee6d 11.0 landed