| From: | Hans-Juergen Schoenig -- PostgreSQL <postgres(at)cybertec(dot)at> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org, zb(at)cybertec(dot)at |
| Subject: | tsvector extraction patch |
| Date: | 2009-07-03 07:49:41 |
| Message-ID: | 4A4DB815.1000702@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
hello,
this patch has not made it through yesterday, so i am trying to send it
again.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hans-Juergen Schoenig -- PostgreSQL | 2009-07-03 08:01:08 | Re: tsvector extraction patch |
| Previous Message | Fujii Masao | 2009-07-03 07:37:46 | Non-blocking communication between a frontend and a backend (pqcomm) |