I'm wondering how I can store word-level bigrams/trigrams in a tsvector
that I can query against. I was expecting the final query to match "the
air" and return the one tuple to me.
For instance:
postgres=# create table docs (a tsvector);
CREATE TABLE
postgres=# insert into docs (a) values (strip('''the air'' smells ''sea
water'''::tsvector));
INSERT 0 1
postgres=# select * from docs;
a
--------------------------------
'sea water' 'smells' 'the air'
(1 row)
postgres=# select * from docs where a @@ to_tsquery('''the air''');
a
---
(0 rows)
Thanks, Alan