PostgreSQL: full text search on entire words
Here is a way I found to make full a full text search on entire words only with postgreSQL (tested on v8.1):
SELECT field1,field2 FROM my_table WHERE field1 SIMILAR TO '[[:<:]]myword[[:>:]]'
Link to this post!