Commit9d35363

committed

Doc: fix prompt in psql crosstabview example

The prompt in the crosstabview example was incorrectly indicatingan open parenthesis where there is none in the example query. Fixby changing to the normal multi-line prompt.Reported-by: y.saburov@gmail.comDiscussion:https://postgr.es/m/171369707837.684.8207966689229976474@wrigleys.postgresql.org

1 parentb53d580 commit9d35363Copy full SHA for 9d35363

File tree

-3

lines changed

-3

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -5309,9 +5309,9 @@ This second example shows a multiplication table with rows sorted in reverse`
`5309`	`5309`	`numerical order and columns with an independent, ascending numerical order.`
`5310`	`5310`	`<programlisting>`
`5311`	`5311`	`testdb=> <userinput>SELECT t1.first as "A", t2.first+100 AS "B", t1.first*(t2.first+100) as "AxB",</userinput>`
`5312`		`-testdb(> <userinput>row_number() over(order by t2.first) AS ord</userinput>`
`5313`		`-testdb(> <userinput>FROM my_table t1 CROSS JOIN my_table t2 ORDER BY 1 DESC</userinput>`
`5314`		`-testdb(> <userinput>\crosstabview "A" "B" "AxB" ord</userinput>`
	`5312`	`+testdb-> <userinput>row_number() over(order by t2.first) AS ord</userinput>`
	`5313`	`+testdb-> <userinput>FROM my_table t1 CROSS JOIN my_table t2 ORDER BY 1 DESC</userinput>`
	`5314`	`+testdb-> <userinput>\crosstabview "A" "B" "AxB" ord</userinput>`
`5315`	`5315`	`A \| 101 \| 102 \| 103 \| 104`
`5316`	`5316`	`---+-----+-----+-----+-----`
`5317`	`5317`	`4 \| 404 \| 408 \| 412 \| 416`

Comments

(0)