News for hackers. Stuff that matters.

A comment on The Many Faces of Distinct in PostgreSQL. Parent comment

Re:The Many Faces of Distinct in PostgreSQL by dymk on Monday May 22, 2023 @12:01PM (#36033133)
Only if there's a separate Departments table, which for this very simple example, there isn't
[ Parent | on HN ]
Re:The Many Faces of Distinct in PostgreSQL by maweki on Monday May 22, 2023 @12:04PM (#36033176)
Even if there were a separate Departments table, who is to say that the Department Name is not its primary key? The Department name certainly is A key.
[ Parent | on HN ]