aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2018-04-04 20:57:26 -0400
committerPeter Eisentraut <peter_e@gmx.net>2018-04-04 20:57:26 -0400
commita56e26784d7f418015a5be471eb500614a2f24ee (patch)
tree7ccd4b131c28c44dadcd457c92a11c64be789299
parent7d7c99790b2a7e6f4e5287a3fb29f73cedbb2105 (diff)
downloadpostgresql-a56e26784d7f418015a5be471eb500614a2f24ee.tar.gz
postgresql-a56e26784d7f418015a5be471eb500614a2f24ee.zip
doc: Improve indentation of SQL examples
Some of these were indented using 8 spaces whereas the rest uses 4 spaces. Probably originally some difference in tab size.
-rw-r--r--doc/src/sgml/queries.sgml72
1 files changed, 36 insertions, 36 deletions
diff --git a/doc/src/sgml/queries.sgml b/doc/src/sgml/queries.sgml
index 19a7d2e18bc..b72be9bf716 100644
--- a/doc/src/sgml/queries.sgml
+++ b/doc/src/sgml/queries.sgml
@@ -1952,14 +1952,14 @@ SELECT <replaceable>select_list</replaceable> FROM <replaceable>table_expression
<programlisting>
WITH regional_sales AS (
- SELECT region, SUM(amount) AS total_sales
- FROM orders
- GROUP BY region
- ), top_regions AS (
- SELECT region
- FROM regional_sales
- WHERE total_sales &gt; (SELECT SUM(total_sales)/10 FROM regional_sales)
- )
+ SELECT region, SUM(amount) AS total_sales
+ FROM orders
+ GROUP BY region
+), top_regions AS (
+ SELECT region
+ FROM regional_sales
+ WHERE total_sales &gt; (SELECT SUM(total_sales)/10 FROM regional_sales)
+)
SELECT region,
product,
SUM(quantity) AS product_units,
@@ -2071,7 +2071,7 @@ WITH RECURSIVE included_parts(sub_part, part, quantity) AS (
SELECT p.sub_part, p.part, p.quantity
FROM included_parts pr, parts p
WHERE p.part = pr.sub_part
- )
+)
SELECT sub_part, SUM(quantity) as total_quantity
FROM included_parts
GROUP BY sub_part
@@ -2093,12 +2093,12 @@ GROUP BY sub_part
<programlisting>
WITH RECURSIVE search_graph(id, link, data, depth) AS (
- SELECT g.id, g.link, g.data, 1
- FROM graph g
- UNION ALL
- SELECT g.id, g.link, g.data, sg.depth + 1
- FROM graph g, search_graph sg
- WHERE g.id = sg.link
+ SELECT g.id, g.link, g.data, 1
+ FROM graph g
+ UNION ALL
+ SELECT g.id, g.link, g.data, sg.depth + 1
+ FROM graph g, search_graph sg
+ WHERE g.id = sg.link
)
SELECT * FROM search_graph;
</programlisting>
@@ -2112,16 +2112,16 @@ SELECT * FROM search_graph;
<programlisting>
WITH RECURSIVE search_graph(id, link, data, depth, path, cycle) AS (
- SELECT g.id, g.link, g.data, 1,
- ARRAY[g.id],
- false
- FROM graph g
- UNION ALL
- SELECT g.id, g.link, g.data, sg.depth + 1,
- path || g.id,
- g.id = ANY(path)
- FROM graph g, search_graph sg
- WHERE g.id = sg.link AND NOT cycle
+ SELECT g.id, g.link, g.data, 1,
+ ARRAY[g.id],
+ false
+ FROM graph g
+ UNION ALL
+ SELECT g.id, g.link, g.data, sg.depth + 1,
+ path || g.id,
+ g.id = ANY(path)
+ FROM graph g, search_graph sg
+ WHERE g.id = sg.link AND NOT cycle
)
SELECT * FROM search_graph;
</programlisting>
@@ -2137,16 +2137,16 @@ SELECT * FROM search_graph;
<programlisting>
WITH RECURSIVE search_graph(id, link, data, depth, path, cycle) AS (
- SELECT g.id, g.link, g.data, 1,
- ARRAY[ROW(g.f1, g.f2)],
- false
- FROM graph g
- UNION ALL
- SELECT g.id, g.link, g.data, sg.depth + 1,
- path || ROW(g.f1, g.f2),
- ROW(g.f1, g.f2) = ANY(path)
- FROM graph g, search_graph sg
- WHERE g.id = sg.link AND NOT cycle
+ SELECT g.id, g.link, g.data, 1,
+ ARRAY[ROW(g.f1, g.f2)],
+ false
+ FROM graph g
+ UNION ALL
+ SELECT g.id, g.link, g.data, sg.depth + 1,
+ path || ROW(g.f1, g.f2),
+ ROW(g.f1, g.f2) = ANY(path)
+ FROM graph g, search_graph sg
+ WHERE g.id = sg.link AND NOT cycle
)
SELECT * FROM search_graph;
</programlisting>
@@ -2295,7 +2295,7 @@ WITH RECURSIVE included_parts(sub_part, part) AS (
SELECT p.sub_part, p.part
FROM included_parts pr, parts p
WHERE p.part = pr.sub_part
- )
+)
DELETE FROM parts
WHERE part IN (SELECT part FROM included_parts);
</programlisting>