pg_search

pg_search copied to clipboard

Student and Tutor are both on the users table. Student belongs to tutor, and Tutor has many students I want my search to return all student records who have a...

maximusdominus

Perhaps you meant to reference the table alias

1

I have the titles and descriptions that are implemented through the STI: ```ruby class Content < ApplicationRecord # ... ``` ```ruby class Title < Content #... ``` ```ruby class Description...

afuno

Adding more columns to Trigger

4

Hello. I'm using pg_search 2.0.1 and a long time ago I did: #Migration ``` def up add_column :users, :tsv, :tsvector add_index :users, :tsv, using: "gin" execute

CarlosUvaSilva

How would I query dates between a range using the pg_search gem?

1

How would I query dates between a range. e.g I want to filter between 10/10/2017 and 10/10/2018 ```ruby class Task < ApplicationRecord include PgSearch scope :sorted, ->{ order(title: :asc) }...

ArthurTruong5

Multisearch not working on a model that uses UUID for a primary key

8

I have a model: ``` sql CREATE TABLE businesses ( id uuid DEFAULT uuid_generate_v4() NOT NULL, slug character varying(255), name character varying(255), phone_number character varying(255), website character varying(255), description text,...

litch

I'm surprised there isn't much information on being able to select case sensitivity..

echan00

Trying to do a joins on a multisearch results in: ActiveRecord::EagerLoadPolymorphicError (Cannot eagerly load the polymorphic association :searchable):

4

When trying to do a multisearch includes, `PgSearch.multisearch(request.headers['search']).includes(:searchable)` the items are being loaded into memory but aren't being returned with the results of pg_search_documents. When trying `PgSearch.multisearch(request.headers['search']).joins(:searchable)` I get the...

jrothrock

##### :advanced Setting this attribute to true will allow you to pass advanced search queries directly to postgres, without pg_search doing any processing on the terms. ```ruby class Number <...

skryl

Add option to disable ranking of results entirely when using pg_search_scope.

6

This PR adds the option to set `ignoring = :rank`, which will cause pg_search to skip ordering the search results entirely, and to remove all calls to ts_rank from the...

undergroundwebdesigns

pg_search_scope error with associations and scopes

26

``` ruby class Establishment < ActiveRecord::Base include PgSearch pg_search_scope :search, against: [:name, :street, :neighborhood, :screen_name], associated_against: { profile: :description, kind_of_foods: [:name, :food] }, using: { tsearch: {prefix: true} }, ignoring:...

danieldocki