pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedhttps://www.postgresql.org/docs/15/tutorial-agg.html
2+ messages / 2 participants
[nested] [flat]
* https://www.postgresql.org/docs/15/tutorial-agg.html
@ 2022-11-18 21:26 PG Doc comments form <noreply@postgresql.org>
2022-11-19 14:40 ` Re: https://www.postgresql.org/docs/15/tutorial-agg.html Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2022-11-18 21:26 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: branyi.laszlo@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/tutorial-agg.html
Description:
city | max | count
---------+-----+-------
Hayward | 37 | 5
(1 row)
it's not right
SELECT city, max(temp_lo), count(*) FILTER (WHERE temp_lo < 30)
FROM weather
GROUP BY city
HAVING max(temp_lo) < 40;
city | max | count
---------+-----+-------
Hayward | 35 | 0
because
SELECT city, max(temp_lo), count(*) FILTER (WHERE temp_lo < 30)
FROM weather
WHERE city LIKE 'S%' -- (1)
GROUP BY city
HAVING max(temp_lo) < 40;
city | max | count
------+-----+-------
(0 rows)
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: https://www.postgresql.org/docs/15/tutorial-agg.html
2022-11-18 21:26 https://www.postgresql.org/docs/15/tutorial-agg.html PG Doc comments form <noreply@postgresql.org>
@ 2022-11-19 14:40 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2022-11-19 14:40 UTC (permalink / raw)
To: branyi.laszlo@gmail.com; +Cc: pgsql-docs@lists.postgresql.org
PG Doc comments form <noreply@postgresql.org> writes:
> Page: https://www.postgresql.org/docs/15/tutorial-agg.html
> Description:
> city | max | count
> ---------+-----+-------
> Hayward | 37 | 5
> (1 row)
> it's not right
Yeah, that example is broken. You can see the repaired text at
https://www.postgresql.org/docs/devel/tutorial-agg.html
but it won't propagate to the released-version docs until
our next releases (scheduled for February).
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-11-19 14:40 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-11-18 21:26 https://www.postgresql.org/docs/15/tutorial-agg.html PG Doc comments form <noreply@postgresql.org>
2022-11-19 14:40 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox