Aleksander Alekseev <a.aleks...@postgrespro.ru> writes: > 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.
How about "cannot cast jsonb $json_type to $sql_type" where $json_type is the type inside the jsonb (e.g. string, number, boolean, array, object)? - ilmari -- "The surreality of the universe tends towards a maximum" -- Skud's Law "Never formulate a law or axiom that you're not prepared to live with the consequences of." -- Skud's Meta-Law
