pg 9.1beta3 typo in 7.2.3

From: Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz>
To: pgsql-docs(at)postgresql(dot)org
Subject: pg 9.1beta3 typo in 7.2.3
Date: 2011-07-15 08:41:31
Message-ID: 4E1FFD3B.5090708@archidevsys.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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 written SELECT * FROM test1 GROUP
BY x, because there is no single value for the column y that could be
associated with each group. The grouped-by columns can be referenced in
the select list since they have a single value in each group.
[...]

The paragraph should read "...SELECT * FROM test1 GROUP BY y..."

Cheers,
Gavin

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Fabio Milillo 2011-07-15 12:54:49 Re: COPY command documentation
Previous Message Alvaro Herrera 2011-07-14 15:37:28 Re: pg_stat_database not in the index 9.0.4