> Um - you're using the full-text indexing. It's > supposed to search words. > > You can use any of the pattern-matching functions / > operators (LIKE etc) > here if you want to explicitly match characters. > http://www.postgresql.org/docs/current/static/functions-matching.html > > If that's not what you're after, you'll need to > explain what you are > trying to do. Id would like to get aproximatly this. WHERE name LIKE 'somes%' But how do I construct FTS query for this? by TheR
