Re: Incorrect FTS results with GIN index
От | Artur Dabrowski |
---|---|
Тема | Re: Incorrect FTS results with GIN index |
Дата | |
Msg-id | 29172950.post@talk.nabble.com обсуждение исходный текст |
Ответ на | Incorrect FTS result with GIN index (Artur Dabrowski <ad@astec.com.pl>) |
Ответы |
Re: Incorrect FTS results with GIN index
|
Список | pgsql-general |
I pasted incorrect query in point 5. It should be: 5. MORE DETAILED QUERY WITH INDEX select keywords from search_tab where (to_tsvector('german', keywords ) @@ to_tsquery('german', 'eeI:*')) and (to_tsvector('german', keywords ) @@ to_tsquery('german', 'dd:*')); keywords -------------------------------------------------------------------------------- lSWN eeIf hInEI IN SIL3WugEOANcEGVWL1L LBAGAeLlGS ttfL DDhuDEIni9 ce tSALWIEEIn-3WNecGAINfLuLAV DDLIWNG E Lt h c8 BiIfgGl1 EeIhulSLenS6LDe5O hGn DDlhIgGEAcS1O eeiEEI WnILWELS68VBLL AGNIAfINt6 lLuWuNeDc ItLfe SL hGe WIiI EeItnLLuA1efOh3ALWc uGINEltcIBE LnegLDNA3 DD SVNG LSSIlWfE eeIW ItueS W39LnELg-GuDLEhAn8BeFG IVi DDNEfLG1SI 1tNIOA lAhNLLccfWISE l 6em on.0nsRH nehSA2l1HAsauncu0I65l7 ddnsn1SAS i u0eLAnlr t70gaains w gzsH eeiog rfiwgso0g364l1 1wU eei1n 5lL dDA 0 DDInNcEfSWAEAtcL1IeSuAG5LE Lilh8tEGeDg f3B eEIOL7h uWV-L1IGN LINWeIn l S ils eeiru00ewH.6sgAeHoSlLhglso0 asn0u2a atisA0 ddcngAnzRA Se Au2 nm8ns0 uS8snH DDD EWlE1GShhLe8L NENI tuL cgGGInfcBAlLfIO L1S eeIWeAEnILStu AViWNI n IOLLt 0Alih tuWNE L nAGlVSNSDI DDeW BIegfG EeIhL9ELeScELWGAIfN1uIc DnSE eeIWLu9tLNhNEuAt I1BelhGGfLWLS nSWINI eiELgAIG DDLEclV7 IO c Af EeIElfN L4I lE2G cSOLniAWgSVItc ILDN L57BuDfALtSIe-WnGhGIW DDA NE1Lhuee hNILN DD L6flSEeW1gthfI L1WAlENE eEIGIAt VGBDO uGLeLccAeSuLWIn Ii nS (14 rows) -- View this message in context: http://old.nabble.com/Incorrect-FTS-results-with-GIN-index-tp29172750p29172950.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
В списке pgsql-general по дате отправления: