Re: tsearch2 dictionary for statute cites - Mailing list pgsql-general

From Kevin Grittner
Subject Re: tsearch2 dictionary for statute cites
Date
Msg-id 49DA442E.EE98.0025.0@wicourts.gov
Whole thread Raw
In response to Re: tsearch2 dictionary for statute cites  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> wrote:
> regexp substitution

I found a way to at least keep the cite in one piece.  Perhaps I can
do the rest in custom dictionaries, which are more pluggable.

select ts_debug
('State Statute <cite value="SS9.125.07(4A)(3)"> pertaining to');
                                    ts_debug
--------------------------------------------------------------------------------
 (asciiword,"Word, all
ASCII",State,{english_stem},english_stem,{state})
 (blank,"Space symbols"," ",{},,)
 (asciiword,"Word, all
ASCII",Statute,{english_stem},english_stem,{statut})
 (blank,"Space symbols"," ",{},,)
 (tag,"XML tag","<cite value=""SS9.125.07(4A)(3)"">",{},,)
 (blank,"Space symbols"," ",{},,)
 (asciiword,"Word, all
ASCII",pertaining,{english_stem},english_stem,{pertain})
 (blank,"Space symbols"," ",{},,)
 (asciiword,"Word, all ASCII",to,{english_stem},english_stem,{})
(9 rows)

-Kevin

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: user defined aggregate for percentile calculations
Next
From: David Kerr
Date:
Subject: Querying Large Objects