Only if there's a separate Departments table, which for this very simple example... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		dymk on May 22, 2023 \| parent \| context \| favorite \| on: The many faces of DISTINCT in Postgres (2017) Only if there's a separate Departments table, which for this very simple example, there isn't

maweki on May 22, 2023 | [–]

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.

Consider applying for YC's Summer 2026 batch! Applications are open till May 4
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact