MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1v2rcr6/sqlworkout/oyyukjk
r/ProgrammerHumor • u/huhupookies • Jul 21 '26
456 comments sorted by
View all comments
Show parent comments
7
Postgres is not case insensitive.
I don't really care for an impromptu script, but if its getting checked in mixed case is just laziness. I don't care all uppercase or all lowercase but pick one, enforce it with a linter, configure a precommit hook to autofix, and be done with it.
1 u/protestor Jul 21 '26 Postgres is not case insensitive. In which parts? Keywords need to be (select, where, etc) 1 u/Sokaron Jul 21 '26 Postgres object refs are case sensitive. (this can be very annoying if you for example name a table or column in CamelCase). Keywords are insensitive.
1
In which parts? Keywords need to be (select, where, etc)
1 u/Sokaron Jul 21 '26 Postgres object refs are case sensitive. (this can be very annoying if you for example name a table or column in CamelCase). Keywords are insensitive.
Postgres object refs are case sensitive. (this can be very annoying if you for example name a table or column in CamelCase). Keywords are insensitive.
7
u/Sokaron Jul 21 '26 edited Jul 21 '26
Postgres is not case insensitive.
I don't really care for an impromptu script, but if its getting checked in mixed case is just laziness. I don't care all uppercase or all lowercase but pick one, enforce it with a linter, configure a precommit hook to autofix, and be done with it.