If I wanted to implement full-text search in #PostgreSQL, what would be the best way to go about it?
Conversation
Notices
-
Embed this notice
洪 民憙 (Hong Minhee) (hongminhee@todon.eu)'s status on Sunday, 16-Jun-2024 18:14:42 JST 洪 民憙 (Hong Minhee)
-
Embed this notice
洪 民憙 (Hong Minhee) (hongminhee@todon.eu)'s status on Sunday, 16-Jun-2024 21:10:32 JST 洪 民憙 (Hong Minhee)
@tshirtman Good to know, cool! Thanks. 🙏🏼
-
Embed this notice
Gabriel Pettier (tshirtman@mas.to)'s status on Sunday, 16-Jun-2024 21:10:33 JST Gabriel Pettier
@hongminhee there is a tsvector datatype for that https://www.postgresql.org/docs/current/textsearch-intro.html the "best" way certainly depends on your constraint, but i would evaluate that first and see if it doesn't match your need, look for solutions more specific to it.
-
Embed this notice