Horton

Thread

Commits

  1. Doc: fix prompt in psql crosstabview example

  1. The prompt is not displayed correctly in the example on psql page

    The Post Office <noreply@postgresql.org> — 2024-04-21T10:57:58Z

    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
```

  2. Re: The prompt is not displayed correctly in the example on psql page

    Daniel Gustafsson <daniel@yesql.se> — 2024-04-22T08:45:15Z

    > 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

  3. Re: The prompt is not displayed correctly in the example on psql page

    Daniel Gustafsson <daniel@yesql.se> — 2024-04-24T11:27:19Z

    > 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