Re: [PERFORM] Performance ts_vector fulltext search

2013-04-11 Thread Tom Lane
Luigi Saggese writes: > I've configured 2 table like this > ... > CREATE INDEX "ix_fulltext_usp_what" ON "public"."User_Statement_Pivot" > ("to_tsvector('italian'::regconfig, ""What""::text)", > "to_tsvector('italian'::regconfig, ""What""::text)"); When I try that I get ERROR: column "to_tsvect

[PERFORM] Performance ts_vector fulltext search

2013-04-11 Thread Luigi Saggese
I've configured 2 table like this CREATE TABLE "public"."User_Statement_Pivot" ( "Email" varchar(50), "UserId" varchar(50), "ShortId" varchar(50), "LastDirectJobMailSentDateTime" int8, "What" varchar(4096), "Where" varchar(4096) ) WITH (OIDS=FALSE) ; ALTER TABLE "public"."User_Statement_Pivot" OW