Gavin Flower writes:
> I think that there is a typo in the paragraph: 'x' used instead of 'y'
> in 'GROUP BY'.
You're mistaken. However, possibly the example is a bit confusing,
because the point is that "SELECT *" includes y, which can't be validly
referenced. Maybe we should spell out "x, y"
I think that there is a typo in the paragraph: 'x' used instead of 'y'
in 'GROUP BY'.
postgres-9.1beta3/share/doc/html/queries-table-expressions.html
7.2.3. The GROUP BY and HAVING Clauses
[...]
=> SELECT x FROM test1 GROUP BY x;
x
---
a
b
c
(3 rows)
In the second query, we could not have
