From: | Mike Rylander <mrylander(at)gmail(dot)com> |
---|---|
To: | Hans-Juergen Schoenig -- PostgreSQL <postgres(at)cybertec(dot)at>, pgsql-hackers(at)postgresql(dot)org, zb(at)cybertec(dot)at |
Subject: | Fwd: tsvector extraction patch |
Date: | 2009-07-08 20:18:31 |
Message-ID: | b918cf3d0907081318r1c9345ffr3e3d96912f1209d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Sorry, forgot to reply-all.
---------- Forwarded message ----------
From: Mike Rylander <mrylander(at)gmail(dot)com>
Date: Wed, Jul 8, 2009 at 4:17 PM
Subject: Re: [HACKERS] tsvector extraction patch
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
On Wed, Jul 8, 2009 at 3:38 PM, Alvaro
Herrera<alvherre(at)commandprompt(dot)com> wrote:
> Mike Rylander escribió:
>> On Fri, Jul 3, 2009 at 3:49 AM, Hans-Juergen Schoenig --
>> PostgreSQL<postgres(at)cybertec(dot)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: miker(at)esilibrary(dot)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: miker(at)esilibrary(dot)com
| web: http://www.esilibrary.com
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-07-08 20:57:33 | Re: *_collapse_limit, geqo_threshold |
Previous Message | Andrew Gierth | 2009-07-08 20:01:28 | hstore patch |