SELECT *,
         cast(json_extract(json_str,'$.val1') as integer) AS val1,
         cast(json_extract(json_str,'$.val2') as integer) AS val2
FROM "db"."table"

@rysk92

株式会社Sprocket

"Sprocket（スプロケット）は、Webサイトにおけるコンバージョン（購入・入会・資料請求・問合せ等）を増やしたい企業様向けに、自社開発のWeb接客ツールの導入及びコンバージョン改善コンサルティングを行っている会社です。 "

https://www.sprocket.bz/

Why not register and get more from Qiita?

We will deliver articles that match you
By following users and tags, you can catch up information on technical fields that you are interested in as a whole
you can read useful information later efficiently
By "stocking" the articles you like, you can search right away

What you can do with signing up