to_tsquery - Does it always accept quert text?

Question

I am very new to FTS features in Postgres, in fact, have started exploring them since yesterday only.

I wanted to pass list of values stored in columns of a DB tables instead of query text in to_tsquery.

Something like this:

select  * 
from t1
 where to_tsvector("col1") @@ to_tsquery((select col2 from t2 where id = 123))

Not sure if this is a possibility? Is there any alternative by which such kind of implementation can be achieved using to_tsquery?

try to make a minimal reproducible example, so that we can understand what you want to achieve — nbk, Commented Feb 28, 2021 at 14:54

Laurenz Albe · Accepted Answer · 2021-03-01 11:52:14Z

1

If the values can be arbitrary strings, you can get errors:

SELECT to_tsquery('a&');
ERROR:  no operand in tsquery: "a&"
SELECT to_tsquery('''q');
ERROR:  syntax error in tsquery: "'q"

Use plainto_tsquery, which is designed to accept plain text strings.

answered Mar 1, 2021 at 11:52

Laurenz Albe

56.4k4 gold badges50 silver badges82 bronze badges

Add a comment |

1 Answer 1