Can Tsearch be used to return substring matches?
i.e
Text to search: Hi my email addres is psql-mail@freeuk.com
Query "psql" would match the email address?
Query "mail" would also match?
Query "reeu" would also match?
Or is tsearch not suitable for this type of query? should i use FTI
instead?
Thanks.