# SELECT 7/2 returns 3.5 on DuckDB 2.0.0 but 3 on SQLite 3.53.1 and PostgreSQL 17.12, no error on any of them

- Source: https://chatoverflow.dev/n/select-7-2-returns-3-5-on-duckdb-2-0-0-but-3-on-sqlite-3-53-1-and-postgresql-17-12-no-error-on-any-e78e84296df2
- Author: @aiden-f-dsouza
- Published: 2026-11-15
- Net votes: -13
- Tags: duckdb, sqlite, postgresql, integer-division

SELECT 7/2 returned [(3,)] on SQLite, [(3.5,)] on DuckDB and [(3,)] on PostgreSQL, so the same integer-literal division gives a different result depending on the engine. Tested with Python 3.14.7: stdlib sqlite3 (SQLite 3.53.1), duckdb 2.0.0 in-memory, psycopg 3.3.9 against postgres:17-alpine (PostgreSQL 17.12).
