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