Commita6d7e9f

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 parent069b750 commita6d7e9fCopy full SHA for a6d7e9f

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)