Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commita56e267

Browse files
committed
doc: Improve indentation of SQL examples
Some of these were indented using 8 spaces whereas the rest uses 4spaces. Probably originally some difference in tab size.
1 parent7d7c997 commita56e267

File tree

1 file changed

+36
-36
lines changed

1 file changed

+36
-36
lines changed

‎doc/src/sgml/queries.sgml

Lines changed: 36 additions & 36 deletions
Original file line numberDiff line numberDiff line change
@@ -1952,14 +1952,14 @@ SELECT <replaceable>select_list</replaceable> FROM <replaceable>table_expression
19521952

19531953
<programlisting>
19541954
WITH regional_sales AS (
1955-
SELECT region, SUM(amount) AS total_sales
1956-
FROM orders
1957-
GROUP BY region
1958-
), top_regions AS (
1959-
SELECT region
1960-
FROM regional_sales
1961-
WHERE total_sales &gt; (SELECT SUM(total_sales)/10 FROM regional_sales)
1962-
)
1955+
SELECT region, SUM(amount) AS total_sales
1956+
FROM orders
1957+
GROUP BY region
1958+
), top_regions AS (
1959+
SELECT region
1960+
FROM regional_sales
1961+
WHERE total_sales &gt; (SELECT SUM(total_sales)/10 FROM regional_sales)
1962+
)
19631963
SELECT region,
19641964
product,
19651965
SUM(quantity) AS product_units,
@@ -2071,7 +2071,7 @@ WITH RECURSIVE included_parts(sub_part, part, quantity) AS (
20712071
SELECT p.sub_part, p.part, p.quantity
20722072
FROM included_parts pr, parts p
20732073
WHERE p.part = pr.sub_part
2074-
)
2074+
)
20752075
SELECT sub_part, SUM(quantity) as total_quantity
20762076
FROM included_parts
20772077
GROUP BY sub_part
@@ -2093,12 +2093,12 @@ GROUP BY sub_part
20932093

20942094
<programlisting>
20952095
WITH RECURSIVE search_graph(id, link, data, depth) AS (
2096-
SELECT g.id, g.link, g.data, 1
2097-
FROM graph g
2098-
UNION ALL
2099-
SELECT g.id, g.link, g.data, sg.depth + 1
2100-
FROM graph g, search_graph sg
2101-
WHERE g.id = sg.link
2096+
SELECT g.id, g.link, g.data, 1
2097+
FROM graph g
2098+
UNION ALL
2099+
SELECT g.id, g.link, g.data, sg.depth + 1
2100+
FROM graph g, search_graph sg
2101+
WHERE g.id = sg.link
21022102
)
21032103
SELECT * FROM search_graph;
21042104
</programlisting>
@@ -2112,16 +2112,16 @@ SELECT * FROM search_graph;
21122112

21132113
<programlisting>
21142114
WITH RECURSIVE search_graph(id, link, data, depth, path, cycle) AS (
2115-
SELECT g.id, g.link, g.data, 1,
2116-
ARRAY[g.id],
2117-
false
2118-
FROM graph g
2119-
UNION ALL
2120-
SELECT g.id, g.link, g.data, sg.depth + 1,
2121-
path || g.id,
2122-
g.id = ANY(path)
2123-
FROM graph g, search_graph sg
2124-
WHERE g.id = sg.link AND NOT cycle
2115+
SELECT g.id, g.link, g.data, 1,
2116+
ARRAY[g.id],
2117+
false
2118+
FROM graph g
2119+
UNION ALL
2120+
SELECT g.id, g.link, g.data, sg.depth + 1,
2121+
path || g.id,
2122+
g.id = ANY(path)
2123+
FROM graph g, search_graph sg
2124+
WHERE g.id = sg.link AND NOT cycle
21252125
)
21262126
SELECT * FROM search_graph;
21272127
</programlisting>
@@ -2137,16 +2137,16 @@ SELECT * FROM search_graph;
21372137

21382138
<programlisting>
21392139
WITH RECURSIVE search_graph(id, link, data, depth, path, cycle) AS (
2140-
SELECT g.id, g.link, g.data, 1,
2141-
ARRAY[ROW(g.f1, g.f2)],
2142-
false
2143-
FROM graph g
2144-
UNION ALL
2145-
SELECT g.id, g.link, g.data, sg.depth + 1,
2146-
path || ROW(g.f1, g.f2),
2147-
ROW(g.f1, g.f2) = ANY(path)
2148-
FROM graph g, search_graph sg
2149-
WHERE g.id = sg.link AND NOT cycle
2140+
SELECT g.id, g.link, g.data, 1,
2141+
ARRAY[ROW(g.f1, g.f2)],
2142+
false
2143+
FROM graph g
2144+
UNION ALL
2145+
SELECT g.id, g.link, g.data, sg.depth + 1,
2146+
path || ROW(g.f1, g.f2),
2147+
ROW(g.f1, g.f2) = ANY(path)
2148+
FROM graph g, search_graph sg
2149+
WHERE g.id = sg.link AND NOT cycle
21502150
)
21512151
SELECT * FROM search_graph;
21522152
</programlisting>
@@ -2295,7 +2295,7 @@ WITH RECURSIVE included_parts(sub_part, part) AS (
22952295
SELECT p.sub_part, p.part
22962296
FROM included_parts pr, parts p
22972297
WHERE p.part = pr.sub_part
2298-
)
2298+
)
22992299
DELETE FROM parts
23002300
WHERE part IN (SELECT part FROM included_parts);
23012301
</programlisting>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp