Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Must skip html tags #2

Open
RouR opened this issue Apr 26, 2021 · 1 comment
Open

Must skip html tags #2

RouR opened this issue Apr 26, 2021 · 1 comment

Comments

@RouR
Copy link

RouR commented Apr 26, 2021

SELECT to_tsvector('public.config_2_gram_cjk', 'Doraemnon Nobita「ドラえもん のび太の牧場物語」多拉A梦 野比大雄χΨψΩω <p>Doraemnon</p>'),
       to_tsquery('public.config_2_gram_cjk', 'のび太'),
       to_tsquery('public.config_2_gram_cjk', '野比大雄'),
       to_tsvector('public.config_2_gram_cjk', 'Doraemnon Nobita「ドラえもん のび太の牧場物語」多拉A梦 野比大雄χΨψΩω <p>Doraemnon</p>') @@       to_tsquery('public.config_2_gram_cjk', 'のび太'),
       to_tsvector('public.config_2_gram_cjk', 'Doraemnon Nobita「ドラえもん のび太の牧場物語」多拉A梦 野比大雄χΨψΩω <p>Doraemnon</p>') @@       to_tsquery('public.config_2_gram_cjk', '野比大雄');
to_tsvector to_tsquery to_tsquery ?column? ?column?
'</p>':25 '<p>':23 'doraemnon':1,24 'nobita':2 'χψψωω':22 '「':3 '」':15 'えも':6 'のび':8 'の牧':11 'び太':9 'もん':7 'ドラ':4 'ラえ':5 '場物':13 '多拉':16 '大雄':21 '太の':10 '梦':18 '比大':20 '牧場':12 '物語':14 '野比':19 'のび' & 'び太' '野比' & '比大' & '大雄' true true

'</p>':25 '<p>':23 - must be filtered

@RouR
Copy link
Author

RouR commented Apr 26, 2021

fast workaround

ALTER TEXT SEARCH CONFIGURATION  public.config_2_gram_cjk
    DROP MAPPING FOR tag

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant