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

>> 1) Does this really pass muster from the translatability standpoint?
>> I doubt it.
Huh, I missed that.

> I think you want the callers to look like
> 
>       if (!JsonbExtractScalar(&in->root, &v) || v.type != jbvNumeric)
>         cannotCastJsonbValue(v.type, "double precision");
> 
> where the subroutine contains the whole ereport() call, and its lookup
> table entries are e.g.
> 
>     gettext_noop("cannot cast jsonb string to type %s")
Thanks for your idea, patch is attached
-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/