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

You’re not technically wrong, but even Postgres’ docs [0] use the term Primary Key.

[0]: https://www.postgresql.org/docs/current/ddl-constraints.html



Postgres primary key indexes are not primary indexes.


I know that, I’m saying that it’s a fairly pedantic argument when even their own docs use the term loosely.


Primary keys are primary indexes are two mostly unrelated terms.


"Primary Key" is the term in SQL standard. The url you linked is in "Part II: The SQL Language"




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: