Home > mailing lists

Full Text Partial Match at begining - Mailing list pgsql-general

From	AI Rumman
Subject	Full Text Partial Match at begining
Date	November 30, 2010 08:06:58
Msg-id	AANLkTikXGZRt8zvSweFyzvLkpuqnfPc0L2BpRW8if7Lh@mail.gmail.com Whole thread Raw
Responses	Re: Full Text Partial Match at begining (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List	pgsql-general

Is it possible to match "%text' in Postgresql 9 Full Text.

select to_tsvector('english','this is advantage') @@ to_tsquery('tage');

I need to get result true for this type of matching.

Any idea please.

From: Dusan Misic
Date: 30 November 2010, 06:29:04
Subject: Re: PostgreSQL hanging on new connections?

From: Craig Ringer
Date: 30 November 2010, 08:21:19
Subject: Re: PostgreSQL hanging on new connections?