Guides

Narrow the list: pick a technology, then a version, then the error you see. Pick any to skip a step. Or type after the cursor, paste an error, or try help.

Nothing here matches. cd / goes back to every guide.

Type to narrow the choices and the guides, or paste an error. Tab completes, ↑ ↓ choose, Enter opens, Backspace on an empty line goes back a step, Esc clears. Commands: cd .., cd /, cd <name>, clear and help.

Error or symptom

• error occurred while decoding column "total_visits": mismatched types; Rust type `i64` (as SQL type `INT8`) is not compatible with SQL type `NUMERIC`
• summary figures read 0 while the table underneath has real rows
• any

1 of 6

1. sqlx: Rust type i64 is not compatible with SQL type NUMERIC

   A SUM() over a BIGINT column comes back as NUMERIC in PostgreSQL, and sqlx refuses to decode that into an i64 field. Casting the sum to BIGINT in the query fixes it.

   ▮▮▯ one layer down / checked 28 Sep 2026 / sqlx 0.8.6 · PostgreSQL / rust · sqlx · postgresql · database