postgres.git / summary / log / commit / refs

commit    ff339f4359424f4a8b5737168a749eff962d7f94
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Sat Mar 21 00:19:32 2020 +0000
First released in: 13.0, 9.5.22, 9.6.18, 10.13, 11.8, 12.3

    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


 doc/src/sgml/textsearch.sgml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/doc/src/sgml/textsearch.sgml b/doc/src/sgml/textsearch.sgml
index 40888a4d207..18ae0976046 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>
 


[parent: d0747714e6ef]