Re: [HACKERS] strange behaviour of parser - numeric domain doesn't work phantom

2007-08-13 Thread Pavel Stehule 
2007/8/13, Tom Lane <[EMAIL PROTECTED]>:
> "Pavel Stehule" <[EMAIL PROTECTED]> 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
>

My mistake. Sorry for noise

regards
Pavel Stehule

---(end of broadcast)---
TIP 6: explain analyze is your friend

Re: [HACKERS] strange behaviour of parser - numeric domain doesn't work phantom

2007-08-13 Thread Tom Lane 
"Pavel Stehule" <[EMAIL PROTECTED]> 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

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate