From: | Viktor Bojović <viktor(dot)bojovic(at)gmail(dot)com> |
---|---|
To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | autogenerated json path |
Date: | 2017-08-31 21:42:43 |
Message-ID: | CAJu1cLZLKx495vTfnah5iWSaReeSZ=XGrrzRaH0D42yvF=mwUA@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
im first time using json data type and i want to autogenerate it, because
im creating crawler which uses postgresql.
This is static example for one site where path should be automatically
generate
SELECT
file_name
,json_data#>>'{1,children,1,children,5,children,3,children,0,children,22,children,0,children,1,children,0,content}'
from src_data
where file_name ~ 'monitor.hr';
in case that i want to add into table another sites and their paths, i
would like to write query which automaticaly changes paths.
SELECT
file_name
,json_data#>>'{''||r.json_path ||''}'
,r.json_path
from src_data d,rules r
where file_name like r.file_name_prefix||'%';
is there any way to write this without writing functions which would slow
process?
--
---------------------------------------
Viktor Bojović
From | Date | Subject | |
---|---|---|---|
Next Message | Viktor Bojović | 2017-09-01 07:59:16 | Re: autogenerated json path |
Previous Message | Abdul Hameed Kareem -X (abdukare - HCL TECHNOLOGIES LIMITED at Cisco) | 2017-08-31 03:48:51 | Re: Substracting Date field from integer value in another field |