Re: [GENERAL] Problem creating GIN index on multiple weighted columns

Ryan Fugger writes: > I'm using 8.4.8, attempting to run the following command: > => create index profile_search_index on profile_profile using > gin(setweight(to_tsvector('english', name), 'A') || > setweight(to_tsvector('english', description), 'B')); > I get this error: > ERROR: syntax error

[GENERAL] Problem creating GIN index on multiple weighted columns

I'm using 8.4.8, attempting to run the following command: => create index profile_search_index on profile_profile using gin(setweight(to_tsvector('english', name), 'A') || setweight(to_tsvector('english', description), 'B')); I get this error: ERROR: syntax error at or near "||" LINE 1: ... gin