Thread: The prompt is not displayed correctly in the example on psql page
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/app-psql.html Description: On this page https://www.postgresql.org/docs/current/app-psql.html where is? >> `( if there is an unmatched left parenthesis` ```sql testdb=> SELECT t1.first as "A", t2.first+100 AS "B", t1.first*(t2.first+100) as "AxB", testdb(> row_number() over(order by t2.first) AS ord testdb(> FROM my_table t1 CROSS JOIN my_table t2 ORDER BY 1 DESC testdb(> \crosstabview "A" "B" "AxB" ord ```
> On 21 Apr 2024, at 12:57, PG Doc comments form <noreply@postgresql.org> wrote: > > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/16/app-psql.html > Description: > > On this page https://www.postgresql.org/docs/current/app-psql.html > > where is? >> `( if there is an unmatched left parenthesis` > > ```sql > testdb=> SELECT t1.first as "A", t2.first+100 AS "B", > t1.first*(t2.first+100) as "AxB", > testdb(> row_number() over(order by t2.first) AS ord > testdb(> FROM my_table t1 CROSS JOIN my_table t2 ORDER BY 1 DESC > testdb(> \crosstabview "A" "B" "AxB" ord > ``` That's an impressively eagle-eyed observation, it is indeed showing an open parenthesis where none is. Will fix. -- Daniel Gustafsson
> On 22 Apr 2024, at 10:45, Daniel Gustafsson <daniel@yesql.se> wrote: > >> On 21 Apr 2024, at 12:57, PG Doc comments form <noreply@postgresql.org> wrote: >> >> The following documentation comment has been logged on the website: >> >> Page: https://www.postgresql.org/docs/16/app-psql.html >> Description: >> >> On this page https://www.postgresql.org/docs/current/app-psql.html >> >> where is? >> `( if there is an unmatched left parenthesis` >> >> ```sql >> testdb=> SELECT t1.first as "A", t2.first+100 AS "B", >> t1.first*(t2.first+100) as "AxB", >> testdb(> row_number() over(order by t2.first) AS ord >> testdb(> FROM my_table t1 CROSS JOIN my_table t2 ORDER BY 1 DESC >> testdb(> \crosstabview "A" "B" "AxB" ord >> ``` > > That's an impressively eagle-eyed observation, it is indeed showing an open > parenthesis where none is. Will fix. Done, thanks for the report! -- Daniel Gustafsson