Column expression without alias. Use explicit
AS clause14 a+(b*c), (a+b)*c -- ditto
15
16
17INSERT INTO mnop (m, n) SELECT i, (1e9 + i/2e4)::float FROM generate_series(1, 2e4) AS i(i) RETURNING NOTHING18
19CREATE TABLE midprimarykeyswapcleanup AS SELECT * FROM generate_series(1,3) AS a;
20-- This schema change is used to enable the primary key swap. The backup is not taken during this schema change.Column expression without alias. Use explicit
AS clause11 d - (a + (b - c)), d - (a - (b + c)), -- ditto
12 ((a1/a2)/(b/c))/((d/e)/f), -- ditto
13 (a+b)*(c*d), -- mixed precedence
14 a+(b*c), (a+b)*c -- ditto15
16
17INSERT INTO mnop (m, n) SELECT i, (1e9 + i/2e4)::float FROM generate_series(1, 2e4) AS i(i) RETURNING NOTHINGColumn expression without alias. Use explicit
AS clause10 d - ((a + b) - c), d - ((a - b) + c), -- ditto
11 d - (a + (b - c)), d - (a - (b + c)), -- ditto
12 ((a1/a2)/(b/c))/((d/e)/f), -- ditto
13 (a+b)*(c*d), -- mixed precedence14 a+(b*c), (a+b)*c -- ditto
15
16Column expression without alias. Use explicit
AS clause 9 d + (a + (b - c)), d + (a - (b + c)), -- ditto
10 d - ((a + b) - c), d - ((a - b) + c), -- ditto
11 d - (a + (b - c)), d - (a - (b + c)), -- ditto
12 ((a1/a2)/(b/c))/((d/e)/f), -- ditto13 (a+b)*(c*d), -- mixed precedence
14 a+(b*c), (a+b)*c -- ditto
15Column expression without alias. Use explicit
AS clause 8 d + ((a + b) - c), d + ((a - b) + c), -- ditto
9 d + (a + (b - c)), d + (a - (b + c)), -- ditto
10 d - ((a + b) - c), d - ((a - b) + c), -- ditto
11 d - (a + (b - c)), d - (a - (b + c)), -- ditto12 ((a1/a2)/(b/c))/((d/e)/f), -- ditto
13 (a+b)*(c*d), -- mixed precedence
14 a+(b*c), (a+b)*c -- dittoColumn expression without alias. Use explicit
AS clause 8 d + ((a + b) - c), d + ((a - b) + c), -- ditto
9 d + (a + (b - c)), d + (a - (b + c)), -- ditto
10 d - ((a + b) - c), d - ((a - b) + c), -- ditto
11 d - (a + (b - c)), d - (a - (b + c)), -- ditto12 ((a1/a2)/(b/c))/((d/e)/f), -- ditto
13 (a+b)*(c*d), -- mixed precedence
14 a+(b*c), (a+b)*c -- dittoColumn expression without alias. Use explicit
AS clause 7 (a + (b - c)) - d, (a - (b + c)) - d, -- ditto
8 d + ((a + b) - c), d + ((a - b) + c), -- ditto
9 d + (a + (b - c)), d + (a - (b + c)), -- ditto
10 d - ((a + b) - c), d - ((a - b) + c), -- ditto11 d - (a + (b - c)), d - (a - (b + c)), -- ditto
12 ((a1/a2)/(b/c))/((d/e)/f), -- ditto
13 (a+b)*(c*d), -- mixed precedenceColumn expression without alias. Use explicit
AS clause 7 (a + (b - c)) - d, (a - (b + c)) - d, -- ditto
8 d + ((a + b) - c), d + ((a - b) + c), -- ditto
9 d + (a + (b - c)), d + (a - (b + c)), -- ditto
10 d - ((a + b) - c), d - ((a - b) + c), -- ditto11 d - (a + (b - c)), d - (a - (b + c)), -- ditto
12 ((a1/a2)/(b/c))/((d/e)/f), -- ditto
13 (a+b)*(c*d), -- mixed precedenceColumn expression without alias. Use explicit
AS clause 6 ((a + b) - c) - d, ((a - b) + c) - d, -- ditto
7 (a + (b - c)) - d, (a - (b + c)) - d, -- ditto
8 d + ((a + b) - c), d + ((a - b) + c), -- ditto
9 d + (a + (b - c)), d + (a - (b + c)), -- ditto10 d - ((a + b) - c), d - ((a - b) + c), -- ditto
11 d - (a + (b - c)), d - (a - (b + c)), -- ditto
12 ((a1/a2)/(b/c))/((d/e)/f), -- dittoColumn expression without alias. Use explicit
AS clause 6 ((a + b) - c) - d, ((a - b) + c) - d, -- ditto
7 (a + (b - c)) - d, (a - (b + c)) - d, -- ditto
8 d + ((a + b) - c), d + ((a - b) + c), -- ditto
9 d + (a + (b - c)), d + (a - (b + c)), -- ditto10 d - ((a + b) - c), d - ((a - b) + c), -- ditto
11 d - (a + (b - c)), d - (a - (b + c)), -- ditto
12 ((a1/a2)/(b/c))/((d/e)/f), -- dittoColumn expression without alias. Use explicit
AS clause 5 (a + (b - c)) + d, (a - (b + c)) + d, -- ditto
6 ((a + b) - c) - d, ((a - b) + c) - d, -- ditto
7 (a + (b - c)) - d, (a - (b + c)) - d, -- ditto
8 d + ((a + b) - c), d + ((a - b) + c), -- ditto 9 d + (a + (b - c)), d + (a - (b + c)), -- ditto
10 d - ((a + b) - c), d - ((a - b) + c), -- ditto
11 d - (a + (b - c)), d - (a - (b + c)), -- dittoColumn expression without alias. Use explicit
AS clause 5 (a + (b - c)) + d, (a - (b + c)) + d, -- ditto
6 ((a + b) - c) - d, ((a - b) + c) - d, -- ditto
7 (a + (b - c)) - d, (a - (b + c)) - d, -- ditto
8 d + ((a + b) - c), d + ((a - b) + c), -- ditto 9 d + (a + (b - c)), d + (a - (b + c)), -- ditto
10 d - ((a + b) - c), d - ((a - b) + c), -- ditto
11 d - (a + (b - c)), d - (a - (b + c)), -- dittoColumn expression without alias. Use explicit
AS clause 4 ((a + b) - c) + d, ((a - b) + c) + d, -- veriffy associativity in sub-expr
5 (a + (b - c)) + d, (a - (b + c)) + d, -- ditto
6 ((a + b) - c) - d, ((a - b) + c) - d, -- ditto
7 (a + (b - c)) - d, (a - (b + c)) - d, -- ditto 8 d + ((a + b) - c), d + ((a - b) + c), -- ditto
9 d + (a + (b - c)), d + (a - (b + c)), -- ditto
10 d - ((a + b) - c), d - ((a - b) + c), -- dittoColumn expression without alias. Use explicit
AS clause 4 ((a + b) - c) + d, ((a - b) + c) + d, -- veriffy associativity in sub-expr
5 (a + (b - c)) + d, (a - (b + c)) + d, -- ditto
6 ((a + b) - c) - d, ((a - b) + c) - d, -- ditto
7 (a + (b - c)) - d, (a - (b + c)) - d, -- ditto 8 d + ((a + b) - c), d + ((a - b) + c), -- ditto
9 d + (a + (b - c)), d + (a - (b + c)), -- ditto
10 d - ((a + b) - c), d - ((a - b) + c), -- dittoColumn expression without alias. Use explicit
AS clause 3 a + (b - c), a - (b + c), -- ditto
4 ((a + b) - c) + d, ((a - b) + c) + d, -- veriffy associativity in sub-expr
5 (a + (b - c)) + d, (a - (b + c)) + d, -- ditto
6 ((a + b) - c) - d, ((a - b) + c) - d, -- ditto 7 (a + (b - c)) - d, (a - (b + c)) - d, -- ditto
8 d + ((a + b) - c), d + ((a - b) + c), -- ditto
9 d + (a + (b - c)), d + (a - (b + c)), -- dittoColumn expression without alias. Use explicit
AS clause 3 a + (b - c), a - (b + c), -- ditto
4 ((a + b) - c) + d, ((a - b) + c) + d, -- veriffy associativity in sub-expr
5 (a + (b - c)) + d, (a - (b + c)) + d, -- ditto
6 ((a + b) - c) - d, ((a - b) + c) - d, -- ditto 7 (a + (b - c)) - d, (a - (b + c)) - d, -- ditto
8 d + ((a + b) - c), d + ((a - b) + c), -- ditto
9 d + (a + (b - c)), d + (a - (b + c)), -- dittoColumn expression without alias. Use explicit
AS clause 2 (a + b) - c, (a - b) + c, -- verify associativity at top
3 a + (b - c), a - (b + c), -- ditto
4 ((a + b) - c) + d, ((a - b) + c) + d, -- veriffy associativity in sub-expr
5 (a + (b - c)) + d, (a - (b + c)) + d, -- ditto 6 ((a + b) - c) - d, ((a - b) + c) - d, -- ditto
7 (a + (b - c)) - d, (a - (b + c)) - d, -- ditto
8 d + ((a + b) - c), d + ((a - b) + c), -- dittoColumn expression without alias. Use explicit
AS clause 2 (a + b) - c, (a - b) + c, -- verify associativity at top
3 a + (b - c), a - (b + c), -- ditto
4 ((a + b) - c) + d, ((a - b) + c) + d, -- veriffy associativity in sub-expr
5 (a + (b - c)) + d, (a - (b + c)) + d, -- ditto 6 ((a + b) - c) - d, ((a - b) + c) - d, -- ditto
7 (a + (b - c)) - d, (a - (b + c)) - d, -- ditto
8 d + ((a + b) - c), d + ((a - b) + c), -- dittoColumn expression without alias. Use explicit
AS clause 1select
2 (a + b) - c, (a - b) + c, -- verify associativity at top
3 a + (b - c), a - (b + c), -- ditto
4 ((a + b) - c) + d, ((a - b) + c) + d, -- veriffy associativity in sub-expr 5 (a + (b - c)) + d, (a - (b + c)) + d, -- ditto
6 ((a + b) - c) - d, ((a - b) + c) - d, -- ditto
7 (a + (b - c)) - d, (a - (b + c)) - d, -- dittoColumn expression without alias. Use explicit
AS clause 1select
2 (a + b) - c, (a - b) + c, -- verify associativity at top
3 a + (b - c), a - (b + c), -- ditto
4 ((a + b) - c) + d, ((a - b) + c) + d, -- veriffy associativity in sub-expr 5 (a + (b - c)) + d, (a - (b + c)) + d, -- ditto
6 ((a + b) - c) - d, ((a - b) + c) - d, -- ditto
7 (a + (b - c)) - d, (a - (b + c)) - d, -- dittoColumn expression without alias. Use explicit
AS clause 1select
2 (a + b) - c, (a - b) + c, -- verify associativity at top
3 a + (b - c), a - (b + c), -- ditto 4 ((a + b) - c) + d, ((a - b) + c) + d, -- veriffy associativity in sub-expr
5 (a + (b - c)) + d, (a - (b + c)) + d, -- ditto
6 ((a + b) - c) - d, ((a - b) + c) - d, -- dittoColumn expression without alias. Use explicit
AS clause 1select
2 (a + b) - c, (a - b) + c, -- verify associativity at top
3 a + (b - c), a - (b + c), -- ditto 4 ((a + b) - c) + d, ((a - b) + c) + d, -- veriffy associativity in sub-expr
5 (a + (b - c)) + d, (a - (b + c)) + d, -- ditto
6 ((a + b) - c) - d, ((a - b) + c) - d, -- dittoColumn expression without alias. Use explicit
AS clause 1select
2 (a + b) - c, (a - b) + c, -- verify associativity at top 3 a + (b - c), a - (b + c), -- ditto
4 ((a + b) - c) + d, ((a - b) + c) + d, -- veriffy associativity in sub-expr
5 (a + (b - c)) + d, (a - (b + c)) + d, -- dittoColumn expression without alias. Use explicit
AS clause 1select
2 (a + b) - c, (a - b) + c, -- verify associativity at top 3 a + (b - c), a - (b + c), -- ditto
4 ((a + b) - c) + d, ((a - b) + c) + d, -- veriffy associativity in sub-expr
5 (a + (b - c)) + d, (a - (b + c)) + d, -- dittoColumn expression without alias. Use explicit
AS clause1select sum(a) over w, avg(b) over (partition by c order by d rows e preceding), min(f) over (order by g range between unbounded preceding and h following exclude ties) from t window w as (partition by i groups between j preceding and current row exclude no others)
Description
It is recommended to use explicit AS clause for column expressions.
Bad practice
In this example, there is no alias for both sums.
SELECT
sum(a),
sum(b)
FROM foo
Recommended
Add aliases.
SELECT
sum(a) AS a_sum,
sum(b) AS b_sum
FROM foo