[GENERAL] Tsearch2 index silently fails on PG 7.3.2

2005-03-20 Thread Justin L. Kennedy
The short question is why does this: select to_tsvector('default', coalesce(name, '') ||' '|| coalesce(description, '') ||' '|| coalesce(keywords,'')) from link_items; give different results than this: update link_items set linksfti=to_tsvector('default', coalesce(name, '') ||' '|| coalesce(d

Re: [GENERAL] Tsearch2 index silently fails on PG 7.3.2

2005-03-20 Thread Oleg Bartunov
I don't remember such problem ? What's your tsearch2 setup ? Oleg On Thu, 17 Mar 2005, Justin L. Kennedy wrote: The short question is why does this: select to_tsvector('default', coalesce(name, '') ||' '|| coalesce(description, '') ||' '|| coalesce(keywords,'')) from link_items; give different resu