Like Search using full text index

[spperl]

Hi,

Does anyone know if it is it possible to do a like search using to_tsquery?


e.g.
to_tsquery('english','search_term*') AS query

or
to_tsquery('english','car*') AS query


this would match car, card, care, cardio etc.. etc..

The tests I have done so far appear to suggest this isn't possible however my knowledge is weak in this area so I would be grateful for any pointers.

Thanks,

 

[spperl]

Hi,

More specific question. The following query does not appear to work on v8.3.14:

select * from table, to_tsquery('english','car:*') as query WHERE to_tsvector('english', title) @@ query

ERROR: syntax error in tsquery: "car:*"

Does anyone know if this functionality was brought in on a later version of postgres?