Thank you all.
In order not to open a new thread, (small clarification)
On the tutorial-agg page in the code example
SELECT city FROM weather WHERE temp_lo = max(temp_lo); WRONG
you need to add a comment before WRONG
> 10 квіт. 2025 р. о 18:13 Tom Lane пише:
>
> Peter Eisentraut writes:
>>
You do not provide the output of the table description, but write that the
system generated the name $2
> 7 квіт. 2025 р. о 16:34 David G. Johnston пише:
>
> On Sunday, April 6, 2025, PG Doc comments form
> wrote:
>> The following documentation comment has been logged on the website:
>>
>>
first query
=> SELECT * FROM test1;
x | y
---+---
a | 3
c | 2
b | 5
a | 1
(4 rows)
second query
=> 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 co
