Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-docs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group