> 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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general