postgres.git / summary / log / commit / refs

commit    1228b2af8e300ab66228ac8fdfac5262a122bcaf
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 67e4901c921..759ea84bcd3 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: 80370836f756]