Is postresql capable of doing a full text search, based on 'half' a word? For example i'm trying to seach foor tree, but i tell postgres to search for 'tr'. I can't find such a solution that is capable of doing this.

Currently i'm using this

 select * from test, to_tsquery('tree') as q where vectors @@ q ;

But i like to do something like this:

 select * from test, to_tsquery('tr%') as q where vectors @@ q ;