Re: Cast jsonb to numeric, int, float, bool - Mailing list pgsql-hackers

From Aleksander Alekseev
Subject Re: Cast jsonb to numeric, int, float, bool
Date
Msg-id 20180330142423.GB1411@e733.localdomain
Whole thread Raw
In response to Re: Cast jsonb to numeric, int, float, bool  (Aleksander Alekseev <a.alekseev@postgrespro.ru>)
Responses Re: Cast jsonb to numeric, int, float, bool  (ilmari@ilmari.org (Dagfinn Ilmari Mannsåker))
List pgsql-hackers
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

Attachment

pgsql-hackers by date:

Previous
From: Aleksander Alekseev
Date:
Subject: Re: Cast jsonb to numeric, int, float, bool
Next
From: David Fetter
Date:
Subject: Re: Feature Request - DDL deployment with logical replication