Skip to content

fix(search): improve multi-language support #164

@dargmuesli

Description

@dargmuesli

Currently, we only add a single search vector fitting the event language.

NEW.search_vector :=
setweight(to_tsvector(ts_config, NEW.name), 'A') ||
setweight(to_tsvector(ts_config, coalesce(NEW.description, '')), 'B');

This makes it difficult to search for events using a different language.

ts_config := maevsi.language_iso_full_text_search(event_search.language);

Either change the current implementation to ignore the language used when generating the vector and when searching, or add a search vector for every supported language.

Metadata

Metadata

Assignees

Labels

good first issueGood for newcomershacktoberfestRecommendation for work that qualifies for hacktoberfest approvals

Type

Projects

Status

👀 In review

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions