Sorry, forgot to reply-all.
---------- Forwarded message ---------- From: Mike Rylander <mrylan...@gmail.com> Date: Wed, Jul 8, 2009 at 4:17 PM Subject: Re: [HACKERS] tsvector extraction patch To: Alvaro Herrera <alvhe...@commandprompt.com> On Wed, Jul 8, 2009 at 3:38 PM, Alvaro Herrera<alvhe...@commandprompt.com> wrote: > Mike Rylander escribió: >> On Fri, Jul 3, 2009 at 3:49 AM, Hans-Juergen Schoenig -- >> PostgreSQL<postg...@cybertec.at> wrote: > >> > 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) >> > >> >> This looks very useful! I wonder if providing a "weight" column would >> be relatively simple? I think this would present problems with the >> cast-to-text[] idea that Peter suggests, though. > > Where would the weight come from? > From a tsvector column that has weights set via setweight(). -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: mi...@esilibrary.com | web: http://www.esilibrary.com -- Mike Rylander | VP, Research and Design | Equinox Software, Inc. / The Evergreen Experts | phone: 1-877-OPEN-ILS (673-6457) | email: mi...@esilibrary.com | web: http://www.esilibrary.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers