Marc Cousin <cousinmarc(at)gmail(dot)com> writes:
> I just got caught by a precedence problem with CREATE OPERATOR.
> Obviously, it was mostly my fault (I didn't think of the precedence of my
> operator at all), but I didn't find anything in the CREATE OPERATOR
> documentation about it either.
CREATE OPERATOR has nothing to say on the subject because operator
precedences are hard-wired into the parser and can't be changed by
CREATE OPERATOR. See
http://www.postgresql.org/docs/8.4/static/sql-syntax-lexical.html#SQL-PRECEDENCE
regards, tom lane