Re: Quoting oddities when defining operators in postgres 8.3

Marc Munro <marc(at)bloodnok(dot)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 is
OPERATOR(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