GNU social JP
  • FAQ
  • Login
GNU social JPは日本のGNU socialサーバーです。
Usage/ToS/admin/test/Pleroma FE
  • Public

    • Public
    • Network
    • Groups
    • Featured
    • Popular
    • People

Conversation

Notices

  1. Embed this notice
    洪 民憙 (Hong Minhee) (hongminhee@todon.eu)'s status on Sunday, 16-Jun-2024 18:14:42 JST 洪 民憙 (Hong Minhee) 洪 民憙 (Hong Minhee)

    If I wanted to implement full-text search in #PostgreSQL, what would be the best way to go about it?

    In conversation about a year ago from todon.eu permalink
    • Embed this notice
      洪 民憙 (Hong Minhee) (hongminhee@todon.eu)'s status on Sunday, 16-Jun-2024 21:10:32 JST 洪 民憙 (Hong Minhee) 洪 民憙 (Hong Minhee)
      in reply to
      • Gabriel Pettier

      @tshirtman Good to know, cool! Thanks. 🙏🏼

      In conversation about a year ago permalink
    • Embed this notice
      Gabriel Pettier (tshirtman@mas.to)'s status on Sunday, 16-Jun-2024 21:10:33 JST Gabriel Pettier Gabriel Pettier
      in reply to

      @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.

      In conversation about a year ago permalink

      Attachments

      1. Domain not in remote thumbnail source whitelist: www.postgresql.org
        12.1. Introduction
        12.1. Introduction # 12.1.1. What Is a Document? 12.1.2. Basic Text Matching 12.1.3. Configurations Full Text Searching (or just text search) …

Feeds

  • Activity Streams
  • RSS 2.0
  • Atom
  • Help
  • About
  • FAQ
  • TOS
  • Privacy
  • Source
  • Version
  • Contact

GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.

Creative Commons Attribution 3.0 All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.