View Single Post

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

> CREATE FULLTEXT CONFIGURATION myfts LIKE template_cfg AS DEFAULT;
> SELECT add_fulltext_config('myfts', 'template_cfg', True);


>That's simple, but what about
>CREATE FULLTEXT MAPPING ON cfgname FOR lexemetypename[, ...] WITH
>dictname1[, ...];
>?
>
>SELECT create_fulltext_mapping(cfgname, '{lexemetypename[, ...]}'::text[],
> '{dictname1[, ...]}'::text[]);
>
>Seems rather ugly for me...


Functions maybe doesn't see efective, but user's cannot learn new syntax.

SELECT create_fulltext_mapping(cfgname, ARRAY['lex..','..'], ARRAY['...'])
is readable.

I agree so enhancing parser oabout not standard construct isn't good.

>And function interface does not provide autocompletion and online help in
>psql. \df says only types of arguments, not a meaning.


Yes, I miss better support function in psql too. But it's different topic. I
don't see reason why
\h cannot support better functions.

Nice a day
Pavel Stehule

__________________________________________________ _______________
Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci.
http://messenger.msn.cz/


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply With Quote