Commitff339f4

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 parentd074771 commitff339f4Copy full SHA for ff339f4

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)