at or near "@": syntax error

[localhosted]

How can I add ts_vector query support?

It's choking on WHERE to_tsvector(unaccent(name)) @@ to_tsquery('portuguese', ':*')

[auxten]

Can you provide the full SQL? Which database and version does this SQL run on?

[localhosted]

It's from the extension pg_trgm

Runs on postgres 9.6+

SELECT
	* 
FROM
	movies 
WHERE
	to_tsvector( unaccent ( NAME ) ) @@to_tsquery( 'portuguese', 'star:*' )