add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TABLE
INSERT 0 1
eml_json_source
{"datasetGPolygon": [{"datasetGPolygonOuterGRing": {"gRingPoint": [{"gRingLatitude": 49.922935, "gRingLongitude": -125.687365}, {"gRingLatitude": 49.639177, "gRingLongitude": -126.126729}, {"gRingLatitude": 49.382373, "gRingLongitude": -125.555556}, {"gRingLatitude": 49.553726, "gRingLongitude": -125.02832}, {"gRingLatitude": 49.95122, "gRingLongitude": -124.852575}, {"gRingLatitude": 50.289339, "gRingLongitude": -125.204066}, {"gRingLatitude": 50.261254, "gRingLongitude": -125.99492}, {"gRingLatitude": 49.922935, "gRingLongitude": -125.687365}]}}, {"datasetGPolygonOuterGRing": {"gRingPoint": [{"gRingLatitude": 49.292889, "gRingLongitude": -124.843625}, {"gRingLatitude": 49.60003, "gRingLongitude": -124.843625}, {"gRingLatitude": 49.60003, "gRingLongitude": -124.409753}, {"gRingLatitude": 49.292889, "gRingLongitude": -124.409753}, {"gRingLatitude": 49.292889, "gRingLongitude": -124.843625}]}}]}
SELECT 1
arr
{"[49.922935,-125.687365]","[49.639177,-126.126729]","[49.382373,-125.555556]","[49.553726,-125.02832]","[49.95122,-124.852575]","[50.289339,-125.204066]","[50.261254,-125.99492]","[49.922935,-125.687365]"}
{"[49.292889,-124.843625]","[49.60003,-124.843625]","[49.60003,-124.409753]","[49.292889,-124.409753]","[49.292889,-124.843625]"}
SELECT 2
arr
{"[49.922935,-125.687365]","[49.639177,-126.126729]","[49.382373,-125.555556]","[49.553726,-125.02832]","[49.95122,-124.852575]","[50.289339,-125.204066]","[50.261254,-125.99492]","[49.922935,-125.687365]"}
{"[49.292889,-124.843625]","[49.60003,-124.843625]","[49.60003,-124.409753]","[49.292889,-124.409753]","[49.292889,-124.843625]"}
SELECT 2