full-text-search Questions
1
I'm running some complex FTS queries in Postgres 13.4 and discovered some behavior in ts_headline that's unexpected, at least to me, and wasn't sure if I've come across a feature or a bug. ;)
Initi...
Circumrotate asked 10/10, 2021 at 4:53
3
I want to realize a fulltext search in postgresql combined with a kind of fuzzy search. For my testarea I followed up this article: https://blog.lateral.io/2015/05/full-text-search-in-milliseconds-...
Prevailing asked 8/9, 2017 at 17:59
3
I'm working on a MongoDB project for my school. I have a Collection of sentences, and I do a normal Text search to find the most similar sentence in the collection, this is based on the scoring.
...
Lelandleler asked 27/3, 2017 at 8:33
5
I have a table of movies, and I want to search on the titles and return the closest match.
I thought full text search might be useful, but it doesn't seem to be able to order by position of the wo...
Trudi asked 26/2, 2016 at 4:51
3
Solved
Given this table:
foos
integer id
string name
string type
And a query like this:
select * from foos where name ilike '%bar%'
I can make a pg_trgm index like this to make lookups faster:
CREATE IN...
Reductase asked 5/2, 2014 at 21:58
7
Solved
I'm building a search for a site, which utilizes a fulltext search. The search itself works great, that's not my problem. I string together user provided keywords (MATCH... AGAINST...) with AND's s...
Ferromagnetism asked 1/10, 2012 at 18:30
6
I'm currently using the websearch_to_tsquery function for full text search in PostgreSQL. It all works well except for the fact that I no longer seem to be able to do partial matches.
SELECT ts_hea...
Merciless asked 5/10, 2020 at 1:13
5
I am having an issue where i want to reduce the number of results from Elastic search to 1,000 no matter how many matching results are there matching, but this should not affect the ranking and sco...
Dutyfree asked 23/1, 2017 at 9:45
5
Solved
I'm using a snowball analyzer to stem the titles of multiple documents. Everything works well, but their are some quirks.
Example:
A search for "valv", "valve", or "valves" returns the same numb...
Mediocre asked 1/2, 2012 at 21:17
2
I am using SQL Server Full Text Search, with the keyword FREETEXTTABLE to return a table of results based on a few columns, searching for a keyword.
Now I have 2 main columns that I am searching o...
Ignace asked 10/11, 2009 at 19:25
4
Solved
Hi I am doing some research before I implement search feature into my service.
I'm currently using PostgreSQL as my main storage. I could definitely use PostgreSQL's built-in Full-Text-Search but ...
Boldface asked 12/11, 2019 at 5:2
4
Solved
How can I create a search results page in Django 1.11, using PostgreSQL full text search, where the terms searched for are highlighted?
Giffy asked 24/9, 2017 at 0:44
2
I have a query that uses phrase search to match whole phrases.
SELECT ts_headline(
'simple',
'This is my test text. My test text has many words. Well, not THAT many words.',
phraseto_tsquery('s...
Figone asked 26/3, 2018 at 16:9
3
Solved
I'm trying to perform a SQLite FTS query with untrusted user input. I do not want to give the user access to the query syntax, that is they will not be able to perform a match query like foo OR bar...
Vinitavinn asked 10/3, 2015 at 18:41
6
I am using SQL Server 2008. I have indexed the ProductName column in the Product table as full text search index. Some ProductName values as examples:
ProductName
-------------
Iphone 3GS
Iphone 4...
Sherrie asked 8/11, 2013 at 10:50
4
Solved
I've installed and configured meilisearch + Laravel Scout package.
My Model:
class Post extends Model
{
use Searchable;
}
When I run php artisan scout:import 'App\Models\Post' it returns:
Importe...
Retortion asked 1/8, 2021 at 23:41
2
I'm currently in the process of building an information search system for my personal documents, and I've been reading about both Vector Databases (in regards to stuff like LangChain), and full-tex...
Klinger asked 7/8, 2023 at 18:46
4
Solved
I have basic stored procedure that performs a full text search against 3 columns in a table by passing in a @Keyword parameter. It works fine with one word but falls over when I try pass in more th...
Cristiano asked 9/8, 2010 at 15:51
3
I'm using Django's inbuilt full text search with PostgreSQL.
The Django docs say that performance can be improved by using a SearchVectorField. That field keeps a pre-generated ts_vector column wit...
Titbit asked 10/1, 2020 at 4:8
3
I have manually created a GIN index on a Postgres table as follows:
create index idx_ib_keywords on stuff using gin(to_tsvector('english'::regconfig, keywords));
It gets created fine:
\d info_b...
Mullens asked 29/6, 2019 at 19:55
2
Here is what I want to do
Lets assume I have an Angular Dart application with a firestore backend that e.g. stores books. Each book has a title, a summary and a published date. Now I want to add a...
Mulderig asked 12/5, 2018 at 14:58
2
Solved
I am quite new to postgresql full text search and I am setting up the configuration as where can I download the ispell *.dict and *.affix filefollowing (exactly as in docs):
CREATE TEXT SEARCH DIC...
Idempotent asked 14/8, 2013 at 11:17
7
Solved
I'm trying to make a search feature that will search multiple columns to find a keyword based match. This query:
SELECT title FROM pages LIKE %$query%;
works only for searching one column, I not...
Swayder asked 25/3, 2010 at 10:8
6
Solved
I would like to search across projects for variable usages, or at least for strings. I've got IndexYourFiles which works well for text searches, but I have to re-index every now and then and would ...
Drudgery asked 8/2, 2011 at 19:7
2
Solved
When trying to index documents with text_general fields I get the following error:
Exception writing document id 93cf6aeb-54b0-471a-9325-5b8e95801131 to the index; possible analysis error: cannot ...
Footbridge asked 6/9, 2019 at 11:46
1 Next >
© 2022 - 2024 — McMap. All rights reserved.