postgreSql 查询语法总结

使用json 格式的查询

记录：

1. PostgreSQL JSONB 使用入门

SELECT * from planning_order


SELECT
(po.level_of_workings :: json ->> 'group') :: TEXT as xx,	* 
FROM
	platform.planning_order po 
WHERE
	(po.level_of_workings :: json -> 'group') :: TEXT = 'GEO' -- 	and json_array_elements(level_of_workings)->>'group' as group
				
SELECT
	* 
FROM
	platform.planning_order po 
WHERE
	ID = 5 
	AND ( po.level_of_workings :: json ->> 'group' ) :: TEXT = 'GEO'
	
	
	select * from planning_order t where t.level_of_workings is not null
	and (t.level_of_workings)::json-> x ->> 'group' like 'GEO'
	;
	
-- 	2
// 对象 这样 没错.
select * from platform.planning_order po where  (po.level_of_workings::json#>'{group}'->'group')::TEXT like 'GEO'

select * from platform.planning_order po where  '[{"group":"GEO","parent":null,"value":"LAS","label":"LAS"},{"group":"COUNTRY","parent":"LAS","value":"MX","label":"Mexico"}]' ::jsonb <@ (po.level_of_workings::jsonb)



	
SELECT  (po.level_of_workings::json->2 ) ::TEXT AS XX FROM  platform.planning_order po

TODO: 一定好好总结一下.