# Database full-text search mogelijkheden/limieten?

**URL:** <https://meta.discourse.org/t/database-full-text-search-capabilities-limits/176590>\
**Category:** Development\
**Created:** [19 januari 2021 om 18:18 UTC](https://meta.discourse.org/t/database-full-text-search-capabilities-limits/176590 "2021-01-19T18:18:23Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![Sailsman63](https://avatars.discourse-cdn.com/v4/letter/s/b5ac83/32.png) [@Sailsman63](https://meta.discourse.org/u/Sailsman63)\
**Post date:** [19 januari 2021 om 18:18 UTC](https://meta.discourse.org/t/database-full-text-search-capabilities-limits/176590/1 "2021-01-19T18:18:23Z")

</div>

Continuing the discussion from [Search results should prioritize first post in topic when title matches search term](https://meta.discourse.org/t/search-results-should-prioritize-first-post-in-topic-when-title-matches-search-term/175154/16):

This is _way_ OT for the original discussion, but I’m not sure whether to be merely surprised, or full-on _appalled_:

> [@Search results should prioritize first post in topic when title matches search term](https://meta.discourse.org/t/search-results-should-prioritize-first-post-in-topic-when-title-matches-search-term/175154/16):
>
> I don’t think we can execute the postgres search query efficiently since there is no index support when trying to match with the `like` and `ilike` operators. Another factor to consider is that **there is no way to rank exact match or contains matches.** This is the reason why we rely full text search capabilities that Postgres provides.

(Emphasis mine)

I’m not about to dispute database choices, as I have _no_ experience here, but this statement implies that Postgres does not differentiate internally between these cases. Is this kind of limit common among database text search engines? If so, that would go far to explain why most site-search facilities are total garbage…

---

_[View the full topic](https://meta.discourse.org/t/database-full-text-search-capabilities-limits/176590)._
