Pavel Stehule wrote: >> > 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.
I am not talking about stored procedures. I am talking about a very ugly, counter intuitive syntax above. Initializing full text should be as simple as: CREATE INDEX foo USING FULLTEXT(bar); (or something similar) Or: CREATE TABLE foo (id serial, names text FULLTEXT); Anything more complicated is a waste of cycles. Joshua D. Drake -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly