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 NOTHING
Column 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
16
Column 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
15
Column 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 -- ditto
Column 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 -- ditto
Column 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 precedence
Column 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 precedence
Column 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), -- ditto
Column 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), -- ditto
Column 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)), -- ditto
Column 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)), -- ditto
Column 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), -- ditto
Column 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), -- ditto
Column 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)), -- ditto
Column 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)), -- ditto
Column 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), -- ditto
Column 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), -- ditto
Column 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, -- ditto
Column 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, -- ditto
Column 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
Column 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
Column 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
Column 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
Column 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)
Column 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