>> CREATE TABLE foo (id serial, names text FULLTEXT); >> >> Anything more complicated is a waste of cycles. >> >> Joshua D. Drake > > I agree. Question: what about multilanguage fulltext. > > CREATE INDEX foo USING FULLTEXT(bar) [ WITH czech_dictionary ]; > CREATE TABLE foo (id serial, names text FULLTEXT [ (czech_dictionary, > english_dictionary) ] ); > > all others can we do via SP.
That works for me with perhaps a default mapping to locales? For example if our locale is en_us.UTF8 we are pretty assured that we are using english. Joshua D. Drake > > Pavel Stehule > > _________________________________________________________________ > Citite se osamele? Poznejte nekoho vyjmecneho diky Match.com. > http://www.msn.cz/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > -- === 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 4: Have you searched our list archives? http://archives.postgresql.org