Re: wrong field in example

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "y(dot)saburov(at)gmail(dot)com" <y(dot)saburov(at)gmail(dot)com>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: wrong field in example
Date: 2024-07-24 12:57:03
Message-ID: CAKFQuwbjP4Z4FGqkY-vAWzc=ZY70DbGKzpLnO=rM7i9sa_w-DQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Tuesday, July 23, 2024, PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/16/queries-table-expressions.html
> Description:
>
> >> 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.
>

I think you mis-copied the query - the one on the page has “select x”, not
“select *”.

David J.

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David Rowley 2024-07-24 13:09:30 Re: wrong field in example
Previous Message Alvaro Herrera 2024-07-24 12:15:31 Re: Incorrect grammar in 15.2