diff options
| author | Bruce Momjian <bruce@momjian.us> | 2020-03-20 20:19:32 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2020-03-20 20:19:32 -0400 |
| commit | 39ceaa275a2ba1397e24278803ca393cc1430050 (patch) | |
| tree | b98112f506adcb8d8bff956f2c64200c79c09c94 | |
| parent | 467b408321e4d3d7a753ecd8d651bf036ce9f3b7 (diff) | |
| download | postgresql-39ceaa275a2ba1397e24278803ca393cc1430050.tar.gz postgresql-39ceaa275a2ba1397e24278803ca393cc1430050.zip | |
docs: use alias in WHERE clause of full text search example
The current doc query specified an alias in the FROM clause and used in
it the target list, but not in the WHERE clause.
Reported-by: axykon@gmail.com
Discussion: https://postgr.es/m/158316348159.30450.16075357948244298217@wrigleys.postgresql.org
Backpatch-through: 9.5
| -rw-r--r-- | doc/src/sgml/textsearch.sgml | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/doc/src/sgml/textsearch.sgml b/doc/src/sgml/textsearch.sgml index d66b4d5d5f9..a6d85ebf4d4 100644 --- a/doc/src/sgml/textsearch.sgml +++ b/doc/src/sgml/textsearch.sgml @@ -200,7 +200,7 @@ WHERE mid = 12; SELECT m.title || ' ' || m.author || ' ' || m.abstract || ' ' || d.body AS document FROM messages m, docs d -WHERE mid = did AND mid = 12; +WHERE m.mid = d.did AND m.mid = 12; </programlisting> </para> |