Skip site navigation (1) Skip section navigation (2)

Re: pg_trgm

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Tatsuo Ishii <ishii(at)postgresql(dot)org>, peter_e(at)gmx(dot)net, ishii(at)sraoss(dot)co(dot)jp, andres(at)anarazel(dot)de, pgsql-hackers(at)postgresql(dot)org, teodor(at)sigaev(dot)ru
Subject: Re: pg_trgm
Date: 2010-05-30 17:51:16
Message-ID: 1902.1275241876@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Greg Stark <gsstark(at)mit(dot)edu> writes:
> There seem to be three behaviours on the table here:

You're neglecting

4) Let the user decide whether he wants pg_trgm to consider word
elements to be "alphanumerics" or "any non-space".

The main problem I have with Tatsuo's patch is that it forecloses any
reasonably upward-compatible extension to a user-selected behavior like
(4).  The current behavior can be extended and is simple to document
(though we've neglected to do so).  But once you've put in this
arbitrary warping of the behavior of C locale, you're going to be at
a dead end for improving it later.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Jan UrbaƄskiDate: 2010-05-30 18:02:05
Subject: Re: tsvector pg_stats seems quite a bit off.
Previous:From: Tom LaneDate: 2010-05-30 17:33:16
Subject: Re: small exclusion constraints patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group