Thread: Missing prefix unary '+' operator in Table 4-2 ?

Missing prefix unary '+' operator in Table 4-2 ?

From
Grzegorz Szpetkowski
Date:
I have question about Table 4-2. Operator Precedence (decreasing) on
http://www.postgresql.org/docs/9.0/static/sql-syntax-lexical.html. I
see there is '-' unary (unary minus) operator listed, but I can't see
'+' (unary plus) prefix operator there. I think that it does not
belong to "(any other)" group as:

SELECT 5 ! + 6;
ERROR:  operator does not exist: integer ! integer
LINE 1: SELECT 5 ! + 6;

Regards,
Grzegorz Szpetkowski

Re: Missing prefix unary '+' operator in Table 4-2 ?

From
Tom Lane
Date:
Grzegorz Szpetkowski <gszpetkowski@gmail.com> writes:
> I have question about Table 4-2. Operator Precedence (decreasing) on
> http://www.postgresql.org/docs/9.0/static/sql-syntax-lexical.html. I
> see there is '-' unary (unary minus) operator listed, but I can't see
> '+' (unary plus) prefix operator there.

Hm, yeah, that probably should be listed.  Will fix.

            regards, tom lane