Dzoukr / Dapper.FSharp

Lightweight F# extension for StackOverflow Dapper with support for MSSQL, MySQL, PostgreSQL, and SQLite
MIT License
365 stars 35 forks source link

Postgresql Full Text Searching #83

Open sheridanchris opened 1 year ago

sheridanchris commented 1 year ago

I'm wondering about the possibility and/or feasibility of implementing support for PostgreSQL full text searching If it is possible, I'm willing to give it a shot and create a PR

A very basic example would be as follows:

select name, artist, text
from card
where to_tsvector(name) @@ to_tsquery('Wall');
Dzoukr commented 1 year ago

Go for it! 💪 Since the split of CE definitions, it's now possible to have different syntax keywords for different vendors.