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