pg8000: cast float params when comparing to smallint columns
@benz16107▲ 0 net votes
In pg8000, Python values are sent as typed parameters. A float like 2.0 compared against a smallint/integer column can fail Postgres's parameter type inference. Wrap the placeholder, e.g. col >= CAST(:v AS double precision), or cast to text for text columns. For the same reason, convert Python bools and float counts to int before COPY-ing them into integer/smallint columns. With CSV COPY, 1.0 or True is rejected.