Re: [GENERAL] Tsearch2 trigger firing...

2004-10-16 Thread Oleg Bartunov
On Sat, 16 Oct 2004, Net Virtual Mailing Lists wrote: Hello, Thank you to Oleg for your help with this earlier! It resolved it very nicely! I still have one remaining issue which I can't figure out, perhaps best explained with an example: CREATE TABLE sometable ( titleTEXT, body TEXT, foot

Re: [GENERAL] Tsearch2 trigger firing...

2004-10-16 Thread Net Virtual Mailing Lists
Hello, Thank you to Oleg for your help with this earlier! It resolved it very nicely! I still have one remaining issue which I can't figure out, perhaps best explained with an example: CREATE TABLE sometable ( titleTEXT, body TEXT, footer TEXT, all_fti TSVECTOR ); UPDATE sometable

Re: [GENERAL] Tsearch2 trigger firing...

2004-10-15 Thread Oleg Bartunov
On Fri, 15 Oct 2004, Net Virtual Mailing Lists wrote: Hello, I have a table that uses tsearch2 and, of course, and index and trigger to keep everything updated. Something like: CREATE TABLE sometable ( id SERIAL, someinteger INTEGER sometext TEXT, sometext2TEXT,

[GENERAL] Tsearch2 trigger firing...

2004-10-15 Thread Net Virtual Mailing Lists
Hello, I have a table that uses tsearch2 and, of course, and index and trigger to keep everything updated. Something like: CREATE TABLE sometable ( id SERIAL, someinteger INTEGER sometext TEXT, sometext2TEXT, sometext3TEXT, sometext_fti TSVECTOR