Re: FTS question - Mailing list pgsql-general

From Damjan Rems
Subject Re: FTS question
Date
Msg-id 779452.4198.qm@web55204.mail.re4.yahoo.com
Whole thread Raw
In response to Re: FTS question  (Richard Huxton <dev@archonet.com>)
Responses Re: FTS question
Re: FTS question
List pgsql-general
> 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







pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Query Fails
Next
From: Jamie Deppeler
Date:
Subject: Need some help