Repository navigation
# is not as -- in PostgreSQL #1646
Description
Activity
You are correct. Reproduction:
> select 17 # 5; +----------+ | ?column? | |----------| | 17 | +----------+Result should be 20 (see PostgreSQL documentation).
This is a known (and old) limitation of one of pgcli dependencies,
sqlparse: andialbrecht/sqlparse#539.pgcli should parse the statement before giving it to sqlparse. Not sure il will be enough to fix the problem.
- added a commit that references this issue
on Sep 21, 2026 ship! my bad!
- added a commit that references this issue
on Sep 21, 2026
pgcli interprets # as a comment mark like -- whereas that is it a XOR operator of binary numbers in PostgreSQL.