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:*' )

[mal-mel]

yeah, i have the similar problem
SELECT * FROM table_name WHERE column1 @@ '$.key == "value"'

[DrakoRod]

I have the same problem using the tsvector and tsquery syntax

error: could not parse sql string: at or near \"@\": syntax error"