hello,

i made a small patch which i found useful for my personal tasks.
it would be nice to see this in 8.5. if not core then maybe contrib.
it transforms a tsvector to table format which is really nice for text 
processing and comparison.

test=# SELECT * FROM tsvcontent(to_tsvector('english', 'i am pretty sure 
this is a good patch'));
  lex   | rank
--------+------
 good   |    8
 patch  |    9
 pretti |    3
 sure   |    4
(4 rows)

    many thanks,

       hans

-- 
Cybertec Schoenig & Schoenig GmbH
Reyergasse 9 / 2
A-2700 Wiener Neustadt
Web: www.postgresql-support.de

Responses

• Re: tsvector extraction patch at 2009-07-02 14:52:44 from Robert Haas
• Re: tsvector extraction patch at 2009-07-02 14:53:11 from Oleg Bartunov

pgsql-hackers by date

Next:	From: Joshua Tolley	Date: 2009-07-02 14:22:14
	Subject: Re: First CommitFest: July 15th
Previous:	From: Dickson S. Guedes	Date: 2009-07-02 13:52:20
	Subject: Re: First CommitFest: July 15th