Pavel Stehule <pavel.stehule@gmail.com> writes:
> try:
> postgres=# select oprcode, oprleft::regtype, oprright::regtype from
> pg_operator where oprname = '#';
Or even easier:
regression=# \do+ #
List of operators
Schema | Name | Left arg type | Right arg type | Result type | Description
------------+------+---------------+----------------+-------------+--------------------------------
pg_catalog | # | bigint | bigint | bigint | bitwise xor
pg_catalog | # | bit | bit | bit | bitwise exclusive or
...
regards, tom lane