SELECT structure_info ::jsonb->> 'FloorMap' as floor_map FROM "floor" WHERE structure_info ::jsonb->> 'FloorMap' is not null
数据库中的结构:
structure_info 的类型为jsonb
SELECT structure_info ::jsonb->> 'FloorMap' as floor_map FROM "floor" WHERE structure_info ::jsonb->> 'FloorMap' is not null
数据库中的结构:
structure_info 的类型为jsonb