From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Not ready for 8.3 |
Date: | 2007-05-15 21:19:30 |
Message-ID: | Pine.LNX.4.64.0705160113050.12152@sn.sai.msu.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, 15 May 2007, Joshua D. Drake wrote:
> Oleg Bartunov wrote:
>> On Tue, 15 May 2007, Joshua D. Drake wrote:
>>
>>> Oleg Bartunov wrote:
>>>> On Tue, 15 May 2007, Joshua D. Drake wrote:
>>>>
>>>>> Tsearch2 in core. I know that Tom has some reservations, he I and Treat
>>>>> all commented on how it was done and to my knowledge those reservations
>>>>> have not been resolved.
>>>>
>>>> We'd like to know about these reservations. If I understand you mean
>>>> there are issues with the patch ? Our patch is several months old. We
>>>> permanently
>>>> keep it in sync with CVS HEAD, latest version is 0.47.
>>>
>>> http://archives.postgresql.org/pgsql-hackers/2007-01/msg01172.php
>>
>> there are several others threads.
>>
>> well, we did answer all raised questions and I don't want to begin
>> another wave.
>
> Did you address them? For example:
>
> http://archives.postgresql.org/pgsql-hackers/2007-03/msg00914.php
we added support of gin index for text data type, so one could just
create index fts_idx on TABLE using gin(body);
and should be able to do full-text search. Of course, ranking is not
available, since index doesn't store positional information.
About this syntax see
http://archives.postgresql.org/pgsql-hackers/2007-03/msg00936.php
>
> Sincerely,
>
> Joshua d. drake
>
>
> The only problem I see is that some people doesn't like
>> introducing SQL syntax, they claim functions would be enough. SQL is a
>> nice language to manipulate db objects, finally. Also, select to
>> fts_create_dictionary(bla-bla....) looks pretty ugly,
>> pretty artificial.
>>
>> CREATE FULLTEXT DICTIONARY dictname [ { INIT init_function
>> | LEXIZE lexize_function
>> | OPTION opt_text } [ ... ]] LIKE template_dictname;
>>
>> select
>>
>>>
>>> Sincerely,
>>>
>>> Joshua D. Drake
>>>
>>
>> Regards,
>> Oleg
>> _____________________________________________________________
>> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
>> Sternberg Astronomical Institute, Moscow University, Russia
>> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
>> phone: +007(495)939-16-83, +007(495)939-23-83
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 7: You can help support the PostgreSQL project by donating at
>>
>> http://www.postgresql.org/about/donate
>>
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-05-15 21:24:37 | Re: Not ready for 8.3 |
Previous Message | Bruce Momjian | 2007-05-15 21:16:46 | Re: Not ready for 8.3 |