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
signature.asc
Description: PGP signature
