postgresql之json操作

最新推荐文章于 2024-11-26 17:11:27 发布

weixin_30315905

最新推荐文章于 2024-11-26 17:11:27 发布

阅读量396

点赞数

文章标签： json 数据库

原文链接：http://www.cnblogs.com/panpanwelcome/p/10341941.html

版权

                  --string 转 json  
                 select '{"Items":[{"Id":1,"InitStartDate":"2018-07-01T00:00:00","InitEndDate":"2018-11-13T11:46:59.461722+08:00",
					 "CurrentStartDate":"","ProcessPercent":0,"State":0}]}'::jsonb into task_config ; 
                   --timestamp 转 字符串，字符串 转 json
		    select  concat('"', to_char(start_date,'YYYY-MM-DD'), '"')::jsonb into startj_date;
		    select  concat('"', to_char(end_date,'YYYY-MM-DD'), '"')::jsonb into endj_date;
                   --修改json中的值
			select jsonb_set(task_config, '{Items,0,InitStartDate}', startj_date, false) into task_config;
			select jsonb_set(task_config, '{Items,0,InitEndDate}',endj_date, false) into task_config;
			RAISE NOTICE 'update task. 
			original TaskConfig:%.
		    new TaskConfig:%',r_bra."TaskConfig",task_config;

转载于:https://www.cnblogs.com/panpanwelcome/p/10341941.html