Commit0c96744

committed

docs: use alias in WHERE clause of full text search example

The current doc query specified an alias in the FROM clause and used init the target list, but not in the WHERE clause.Reported-by: axykon@gmail.comDiscussion:https://postgr.es/m/158316348159.30450.16075357948244298217@wrigleys.postgresql.orgBackpatch-through: 9.5

1 parente8a6391 commit0c96744Copy full SHA for 0c96744

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -200,7 +200,7 @@ WHERE mid = 12;`
`200`	`200`
`201`	`201`	`SELECT m.title \|\| ' ' \|\| m.author \|\| ' ' \|\| m.abstract \|\| ' ' \|\| d.body AS document`
`202`	`202`	`FROM messages m, docs d`
`203`		`-WHERE mid = did AND mid = 12;`
	`203`	`+WHEREm.mid =d.did ANDm.mid = 12;`
`204`	`204`	`</programlisting>`
`205`	`205`	`</para>`
`206`	`206`

Comments

(0)