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
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:
>>
>>
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:
>>
Sorry, my mistake.
> 7 серп. 2025 р. о 15:15 Daniel Gustafsson пише:
>
>
>>
>>> On 7 Aug 2025, at 08:22, PG Doc comments form
>>> wrote:
>>
>> In section 29.5. Column Lists there are two identical subsections '29.5.1.
>> Examples', with the same link
>
> The first link on the page, in red
