Re: How to enable partial matching on a GIN index

From: Chris Spencer <chrisspen(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: How to enable partial matching on a GIN index
Date: 2016-01-11 21:31:24
Message-ID: CANe40gLW_yabLh-D93Q+Pt7MZkoD+dorbA8ArEExwnFebo1SKg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

>This isn't right, you have to use
>
> to_tsquery('pg_catalog.english', 'hosp:*')

Thanks, that was my problem.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Alexander Law 2016-01-17 15:34:15 Re: Graphic to visualize data flow between processes, buffers and files
Previous Message Tom Lane 2016-01-11 20:33:37 Re: How to enable partial matching on a GIN index