Hello Teodor, > > 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.
On second thought this message is misleading. We can cat jsonb to bool, the problem is that the document is not a bool value. -- Best regards, Aleksander Alekseev
signature.asc
Description: PGP signature
