View Single Post

   
  #4 (permalink)  
Old 04-12-2008, 08:16 AM
Pavel Stehule
 
Posts: n/a
Default Re: tsearch in core patch, for inclusion

> > And users are constantly complaining that PostgreSQL doesn't have
> > fulltext indexing capabilities (if they don't know about tsearch2) or
> > about how hard it is to use tsearch2.
> >
> >> SELECT create_fulltext_mapping(cfgname, ARRAY['lex..','..'],
> >> ARRAY['...']) is readable.

> >
> > Hardly. Because it's not like SQL:

>
>I have to agree here.
>
>SELECT create_fulltext_mapping(cfgname, ARRAY['lex..','..'],
>ARRAY['...']) is readable.
>
>Is a total no op. We might as well just leave it in contrib.
>


I am for integration tsearch to core, why not. But I don't see reason for
special syntax. Stored procedures is exactly good tool for it.

Fulltext is standarised in SQL/MM, SQL Multimedia and Application Packages,
Part 2: Full-Text

Why implement extensive proprietary solution? If our soulution is
proprietary, then so it is simple and cheap and doesn't complicate future
conformance with ANSI SQL.

Regards
Pavel Stehule

__________________________________________________ _______________
Najdete si svou lasku a nove pratele na Match.com. http://www.msn.cz/


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote