Skip to main content
2 of 3
edited tags

Postgresql full text search partial search with `in:*` not working

select to_tsvector('english', 'JAVA') @@ to_tsquery('english','ja:*');

select to_tsvector('english', 'india') @@ to_tsquery('english','in:*');

The first one is returning true while the second is returning false. How to address this?