Operator Invocations

There are two possible syntaxes:

• expression operator expression (binary infix operator):

  mydb=> SELECT 2 + 3;
  ?column? 
  ----------
          5
  (1 row)
  

  mydb=> SELECT 2 OPERATOR(pg_catalog.+) 3;  --schema-qualified operator name
  ?column? 
  ----------
          5
  (1 row)
  

• operator expression (unary prefix operator):

  mydb=> SELECT -3;
  ?column? 
  ----------
        -3
  (1 row)