On Monday, May 21, 2012 07:26:38 PM wbr...@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 6654
> Logged by: wbrana
> Email address: wbr...@gmail.com
> PostgreSQL version: 9.1.3
> Operating system: Linux
> Description:
>
> CREATE INDEX idx_post_text ON posts USING gin
> (to_tsvector('english'::regconfig, post_text::text))
> select * from v_search WHERE to_tsvector('english', post_text) @@ 'europe'
> returns no rows, but
> select * from v_search WHERE to_tsvector('english', post_text) @@ 'japan'
> returns row with "Japan and Europe"
The problem is that youre using to_tsvector('english' for parsing the text but
don't specify the text yearch configuration for the query. The default english
configuration does stemming, the default_text_search_configuration obviously
not.
Try ... to_tsvector('english', post_text) @@ to_tsquery('english', 'europe')
Andres
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
