Luigi Saggese <luigisag@xxxxxxxxx> 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_tsvector('italian'::regconfig, "What"::text)" does not exist
as indeed I should, because you seem to be confused about SQL quoting
rules --- that whole expression is being taken as a name. However, the
bigger problem here is that you're creating btree indexes, which are not
useful for full text search. They need to be gin or gist indexes. See
examples at
http://www.postgresql.org/docs/9.2/static/textsearch-tables.html#TEXTSEARCH-TABLES-INDEX
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
