From: | Tim Uckun <timuckun(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Partial matches on full text searches. |
Date: | 2012-02-29 03:25:24 |
Message-ID: | CAGuHJrMmesWoG7ZgHzxtRXOc-2T-CTEh1Et7jLt9fwkVhKXo0g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am trying to understand this bit of documentation about GIST and GIN searches
Also, * can be attached to a lexeme to specify prefix matching:
SELECT to_tsquery('supern:*A & star:A*B');
to_tsquery
--------------------------
'supern':*A & 'star':*AB
I tried various experiments but can't seem to be able to pinpoint a
way to matches similar to ILIKE.
Let's say I want to query some addresses and I want to find be able to
differentiate between PARK LANE and LINCOLN PARK and SPARK STREET how
do I specify these in a tsquery?
Also...
Is it possible to do partial matches on values in a hstore I would
like to differentiate between ADDRESS=>"PARK LANE" and LAST_NAME=>PARK
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2012-02-29 04:02:55 | Re: synchronous replication: blocking commit on the master |
Previous Message | Scott Marlowe | 2012-02-29 01:16:40 | Re: Four issues why "old elephants" lack performance: Explanation sought Four issues why "old elephants" lack performance: Explanation sought |