Re: Analyzing PostgreSQL Email Archives with PostgreSQL - Mailing list pgsql-advocacy

From Kevin Grittner
Subject Re: Analyzing PostgreSQL Email Archives with PostgreSQL
Date
Msg-id 1360102853.90171.YahooMailNeo@web162905.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: Analyzing PostgreSQL Email Archives with PostgreSQL  (Robert Bernier <robert@pg-live.info>)
List pgsql-advocacy
Robert Bernier <robert@pg-live.info> wrote:

> Still it would be nice if people could mention here on the list
> real world use-cases using text-search.

The Wisconsin Supreme Court and Court of Appeals software uses
tsearch2 against text extracted from PDF documents to allow
justices, appeals court judges, and their clerks to search filings,
motions, opinions, etc.  Custom dictionaries are added to the
dictionary chain to allow accurate recognition of legal phrases
like "amicus curiae" or "power of attorney", and the lexemes
generated by the dictionaries are combined with the results of
passing the text with a regular expression search to find dates,
case numbers, and statute cites (which get higher priority in the
searches).  If any portion of the search string entered by the user
has quotes around it, the normal tsearch2 results are further
filtered by looking for an exact match on the quoted string.

-Kevin



pgsql-advocacy by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Analyzing PostgreSQL Email Archives with PostgreSQL
Next
From: Gavin Flower
Date:
Subject: Re: Analyzing PostgreSQL Email Archives with PostgreSQL