From: Daniel Gustafsson <daniel@yesql.se>
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.500.171.1.1\))
Subject: Re: The prompt is not displayed correctly in the example on psql page
Date: Mon, 22 Apr 2024 10:45:15 +0200
References: <171369707837.684.8207966689229976474@wrigleys.postgresql.org>
To: y.saburov@gmail.com,
 Pg Docs <pgsql-docs@lists.postgresql.org>
In-Reply-To: <171369707837.684.8207966689229976474@wrigleys.postgresql.org>
Message-Id: <C71DCBC4-2CC2-44D9-8B0F-B7DB6BEA3E52@yesql.se>
Archived-At: 
 <https://www.postgresql.org/message-id/C71DCBC4-2CC2-44D9-8B0F-B7DB6BEA3E52%40yesql.se>
Precedence: bulk

> On 21 Apr 2024, at 12:57, PG Doc comments form =
<noreply@postgresql.org> wrote:
>=20
> The following documentation comment has been logged on the website:
>=20
> Page: https://www.postgresql.org/docs/16/app-psql.html
> Description:
>=20
> On this page https://www.postgresql.org/docs/current/app-psql.html
>=20
> where is?  >> `( if there is an unmatched left parenthesis`
>=20
> ```sql
> testdb=3D> 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