"Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> writes:
> postgres=# select -11::nb;
The operator precedence table at
http://developer.postgresql.org/pgdocs/postgres/sql-syntax-lexical.html#SQL-PRECEDENCE
says perfectly clearly that :: binds more tightly than -.
regards, tom lane