Re: Quoting oddities when defining operators in postgres 8.3

Marc Munro <marc@bloodnok.com> writes:
> It seems that the operator name in the create operator clause cannot be
> quoted, but in the commutator, or negator clauses, if schema-qualified,
> the operator must be quoted.  If not schema-qualified it seems there is
> no need for quoting.

The correct way to write a schema-qualified operator name isOPERATOR(foo.<)
You can get away without the OPERATOR() decoration immediately after
CREATE OPERATOR, since it's known that an operator name must appear
there, but within the definition-item list the parser is stickier
about this.  It's more or less an implementation artifact that
foo."<" works at all, because that's not an operator name, it's
a regular identifier.
        regards, tom lane