-
Notifications
You must be signed in to change notification settings - Fork 111
Open
Description
The output of this SQL is very hard to read. The closing line of st_union should be on the same line and the indentation is all messed up
Input:
CREATE TEMPORARY TABLE IF NOT EXISTS square_poly2 AS (
WITH united AS (
SELECT
level,
st_union (st_buffer (geom, 0.01)) AS geom
FROM
osmgrid._a_polygones
GROUP BY
level
),
united2 AS (
SELECT
level,
st_union (st_buffer (geom, 0.01)) AS geom
FROM
osmgrid._a_polygones
GROUP BY
level
)
SELECT
*
FROM
united
);Output:
CREATE TEMPORARY TABLE IF NOT EXISTS square_poly2 AS (
WITH united AS (
SELECT
level,
st_union (st_buffer (geom, 0.01)
) AS geom
FROM
osmgrid._a_polygones
GROUP BY
level),
united2 AS (
SELECT
level,
st_union (st_buffer (geom, 0.01)
) AS geom
FROM
osmgrid._a_polygones
GROUP BY
level
)
SELECT
*
FROM
united
);Metadata
Metadata
Assignees
Labels
No labels