Return to Answer

added 3 characters in body

Source Link

edited Oct 16, 2019 at 1:05

Just use the simple text search configuration, which works with the simple dictionary and does not do any stemming:

CREATE INDEX ON tbl USING GIN (to_tsvector('simple', data));

AnAnd query accordingly:

SELECT *
FROM   tbl
WHERE  to_tsvector('simple', data) @@ to_tsquery('simple', 'foo');

Just use the simple text search configuration, which works with the simple dictionary and does not do any stemming:

CREATE INDEX tbl USING GIN (to_tsvector('simple', data));

An query accordingly:

SELECT *
FROM   tbl
WHERE  to_tsvector('simple', data) @@ to_tsquery('simple', 'foo');

Just use the simple text search configuration, which works with the simple dictionary and does not do any stemming:

CREATE INDEX ON tbl USING GIN (to_tsvector('simple', data));

And query accordingly:

SELECT *
FROM   tbl
WHERE  to_tsvector('simple', data) @@ to_tsquery('simple', 'foo');

Source Link

created Oct 16, 2019 at 0:55

Just use the simple text search configuration, which works with the simple dictionary and does not do any stemming:

CREATE INDEX tbl USING GIN (to_tsvector('simple', data));

An query accordingly:

SELECT *
FROM   tbl
WHERE  to_tsvector('simple', data) @@ to_tsquery('simple', 'foo');