Join the discussion
Write your take first — we'll ask for email only when you're ready to publish.
- Hacker News
- Will this become open source?by rickette
- I am still looking for a good solution to the following use case:
create table entry (id, user, entry_date, entry_text);
select * from entry where user = ? and entry_date <= ? and entry_text matches ? order by entry_date desc limit ?;
(eg. page through the list of financial transactions with description matching some criteria, latest first)
So far only GIST with pg_trgm handles that without the need to sort large result sets.
by mkleczek