pg_search

pg_search copied to clipboard

Thanks for this gem it's really useful ! I have an issue I'm stuck with. I'm using multisearch method and I would like to have the search term "American psycho"...

Joel-Mercier

When performing tsearch with Highlighting, the resulting query result concatenates the searched columns with a space. It can be hard to extract the different column data result if both data...

paulRbr

Search documents with blank content

1

It is possible for the user to reference an attribute or attributes for `multisearchable` that contains no data. If there is no data for the `content` of the pg_search_document, a...

vanboom

Search rank subquery generates unuseable query plan under certain conditions

16

I've been troubleshooting an odd issue that came to the fore today. Our `responses` table has 300,000+ entries, but they are always filtered by a `project_id`, which is an indexed...

ajb

Error when attempting to cache

2

I'm trying to cache queries on the most frequently accessed page on my site. I'm getting an error when adding `Rails.cache`. The page loads fine without caching. ### error ```...

antarr

SQL error when using pg_search in combination with eager_load or includes with references

2

Basically, I'm reopening isssue #330 as it's still happening on version 2.3.5. This works: `Book.includes(:author).where.not(authors: { name: 'Kevin' })` But this doesn't: `Book.includes(:author).where.not(authors: { name: 'Kevin' }).search('sometitle')` The error I...

JosephTico

How to use pg_search_scope with Mobility for translated attributes?

2

Hi guys, great gem for sure, but some questions are not really clear for me. How can i use pg_search_scope in combination with Mobility for translated attributes? Available languages are...

axcr

Support for augmenting with websearch_to_tsquery()

5

As seen here: https://www.postgresql.org/docs/11/functions-textsearch.html I would assume this happens at the call level: ``` ruby class Post < ApplicationRecord pg_search_scope :search_by_title, against: :title end ``` ``` ruby Post.search_by_title("word|word") Post.search_by_title.websearch("word or...

krainboltgreene

I'm moving from using search scopes to multi-search because of performance issue when searching associations. I have a search bar and and 3 optional filters to filter the results. The...

bradbajuz

Using generated columns instead of triggers

1

Hi. I _think_ I did this correctly, but our searches are awfully slow and I'm trying to verify that I've done things correctly. Here are the indexes. ```ruby execute( explain...

ClayShentrup