postgres.git / summary / log / commit / refs

commit    514aca63ea565b23756282bd6c77eb30fc9398b7
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 fe630a66b34..86cada5eb5c 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: 3163349fd7fe]