How to use parameters in report builder with a Postgresql DB using odbc?

Hi all,

I am having problems using a parameter in a paginated report with a postgresql database.
I am using an ODBC connection to connect to postgresql.

This is the test query I am using:

with my_data as (
      select 0001 as customer_number, 'New York' as city 
union select 0002 as customer_number, 'Paris' as city
)
select 
    * 
from 
    my_data
where 
    city = (@city)

When I run the script, I get this error message:
An error occurred while executing the query.
ERROR [42883] ERROR: operatot does not exist: @ text;
Error while executing the query

This query works fine for an Orcale DB using this syntax:

where 
    city = (:city)

But this also fails for Postgres.

Can anyone tell me how the synax for using a parameter in the report builder is if using a Postgres DB?

Thanks in advance