Comments (3)
I believe https://docs.paradedb.com/search/full-text/bm25#efficient-filtering would work
from paradedb.
We also just completed work in #876 to expose more of the power of Tantivy's query interface to Postgres. This will allow you to compose together queries.
Nearly all of Tantivy's queries are implemented, but one of the notable omissions is the Range query, which is likely most relevant to you. If you look through #876, you'll see that Range is mostly implemented, but not yet exposed to Postgres. It needs more testing before we consider it ready to go. I would be happy to support if you wanted to take that on.
In the meantime, you should be able to use the syntax that @rebasedming suggested. You can pass a query string directly to the search
function, or you can use the query builder interface we just released:
https://docs.paradedb.com/search/full-text/complex
from paradedb.
Going to close this unless a new report comes
from paradedb.
Related Issues (20)
- Multi tenant implementation - using existing postgres setup HOT 4
- pg_search-v0.8.2-ubuntu-22.04-amd64-pg16.deb postgresql-16:amd64 : Depends: libc6:amd64 HOT 10
- FATAL: could not access file "pg_cron": No such file or directory HOT 2
- UuidConversionError when doing rank_hybrid with UUID id HOT 1
- Fix documentation for Docker image upgrades HOT 1
- Push down `quals` in foreign table scan HOT 3
- Bug: Time interval "CAST((NOW() + INTERVAL '-40 day')" leads to error HOT 7
- Augment ParadeDB with DuckDB syntax HOT 14
- Remove `pg_analytics` documentation
- DATE_TRUNC('day', date_day) not supported HOT 1
- JSON not supported HOT 2
- Error when using `IN` search in numerical index HOT 2
- rank_bm25 different with term_set and should(terms) HOT 1
- Could not store search result in state manager
- Create BM25 index over JOINs of tables HOT 1
- Inserts into different BM25 indexes in the same transaction are ignored
- PREPARE statement doesn't work HOT 2
- Occasionally could not lookup doc address for search query: DocLookup(TantivyValue(I64(260))) HOT 3
- Add S3 `pg_lakehouse` benchmarks to `cargo-paradedb`
- TablePlus can't get schema information of DuckDB tables HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from paradedb.