diff options
| author | Daniel Gustafsson | 2024-04-24 11:09:50 +0000 |
|---|---|---|
| committer | Daniel Gustafsson | 2024-04-24 11:09:50 +0000 |
| commit | 9d353639c3b37efea7a29b63027cef81a7c7e335 (patch) | |
| tree | d67034b29c638a43a718d25e0ba224a9147e871d | |
| parent | b53d58097d7d5712d819d06e0416dec0a7db2479 (diff) | |
Doc: fix prompt in psql crosstabview example
The prompt in the crosstabview example was incorrectly indicating
an open parenthesis where there is none in the example query. Fix
by changing to the normal multi-line prompt.
Reported-by: y.saburov@gmail.com
Discussion: https://postgr.es/m/171369707837.684.8207966689229976474@wrigleys.postgresql.org
| -rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 4ad2cb1d991..830306ea1e2 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -5309,9 +5309,9 @@ This second example shows a multiplication table with rows sorted in reverse numerical order and columns with an independent, ascending numerical order. <programlisting> testdb=> <userinput>SELECT t1.first as "A", t2.first+100 AS "B", t1.first*(t2.first+100) as "AxB",</userinput> -testdb(> <userinput>row_number() over(order by t2.first) AS ord</userinput> -testdb(> <userinput>FROM my_table t1 CROSS JOIN my_table t2 ORDER BY 1 DESC</userinput> -testdb(> <userinput>\crosstabview "A" "B" "AxB" ord</userinput> +testdb-> <userinput>row_number() over(order by t2.first) AS ord</userinput> +testdb-> <userinput>FROM my_table t1 CROSS JOIN my_table t2 ORDER BY 1 DESC</userinput> +testdb-> <userinput>\crosstabview "A" "B" "AxB" ord</userinput> A | 101 | 102 | 103 | 104 ---+-----+-----+-----+----- 4 | 404 | 408 | 412 | 416 |