Re: FTS question

From: Damjan Rems <d_rems(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: FTS question
Date: 2008-07-01 08:14:12
Message-ID: 779452.4198.qm@web55204.mail.re4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jamie Deppeler 2008-07-01 08:37:07 Need some help
Previous Message A. Kretschmer 2008-07-01 08:12:30 Re: Query Fails