On Mon, 12 Jul 2021, Adrian Klaver wrote:
You should also follow Tom's suggestion and do:
\do+ &
in psql.
It's the bitwise 'and':
# \do+ &
List of operators
Schema | Name | Left arg type | Right arg type | Result type | Function | Description
------------+------+---------------+----------------+-------------+--------------+-------------
pg_catalog | & | bigint | bigint | bigint | int8and
| bitwise and
pg_catalog | & | bit | bit | bit | bitand
| bitwise and
pg_catalog | & | inet | inet | inet | inetand
| bitwise and
pg_catalog | & | integer | integer | integer | int4and
| bitwise and
pg_catalog | & | macaddr | macaddr | macaddr | macaddr_and
| bitwise and
pg_catalog | & | macaddr8 | macaddr8 | macaddr8 |
macaddr8_and | bitwise and
pg_catalog | & | smallint | smallint | smallint | int2and
| bitwise and
(7 rows)
which doesn't seem appropriate in this context.
Thanks,
Rich
