Pavel Stehule <pavel.stehule@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general