postgres.git / summary / log / commit / refs

commit    a6d7e9fb2816fcd23e5d1e95a52448eb9acf7f6e
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Sat Mar 21 00:19:32 2020 +0000

    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 9839eaa8dd2..c5b254c7ca9 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: 069b750ca764]