Re: Extract numeric filed in JSONB more effectively
| От | Andy Fan |
|---|---|
| Тема | Re: Extract numeric filed in JSONB more effectively |
| Дата | |
| Msg-id | CAKU4AWp+KLes8g=BWLqZfDmW9+=ZY0UC4G0i3qVcYEviK_dDTA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Extract numeric filed in JSONB more effectively (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: Extract numeric filed in JSONB more effectively
Re: Extract numeric filed in JSONB more effectively |
| Список | pgsql-hackers |
We'd still have functions like jsonb_field_as_numeric() under the
hood, but there's not an expectation that users call them explicitly.
To avoid the lots of functions like jsonb_field_as_int2/int4, I defined
Datum jsonb_object_field_type(.., Oid target_oid) at last, so the
function must return "internal" or "anyelement". Then we can see:
ERROR: cannot display a value of type anyelement.
The reason is clear to me, but I'm not sure how to fix that or deserves
a fix? Or shall I define jsonb_object_field_int2/int8 to avoid this?
This is an unresolved issue at the latest patch.
Best Regards
Andy Fan
В списке pgsql-hackers по дате отправления: