Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Haas
Subject Re: Cast jsonb to numeric, int, float, bool
Date
Msg-id CA+TgmoaYgUkbrpzYgBPhH31+9BioCRs3RF2Bcz8E-+zttcCB4A@mail.gmail.com
Whole thread Raw
In response to Re: Cast jsonb to numeric, int, float, bool  (ilmari@ilmari.org (Dagfinn Ilmari Mannsåker))
Responses Re: Cast jsonb to numeric, int, float, bool
List pgsql-hackers
Tree view 
On Fri, Mar 30, 2018 at 11:21 AM, Dagfinn Ilmari Mannsåker
<ilmari@ilmari.org> wrote:
> 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)?

Yes, that sounds pretty good.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Having query cache in core
Next
From: Tom Lane
Date:
Subject: Re: Refreshing findoidjoins for v11