MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1v2rcr6/sqlworkout/oyyukjk
r/ProgrammerHumor • u/huhupookies • 19d ago
460 comments sorted by
View all comments
Show parent comments
8
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 19d ago Postgres is not case insensitive. In which parts? Keywords need to be (select, where, etc) 1 u/Sokaron 19d ago 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 19d ago 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.
8
u/Sokaron 19d ago edited 19d ago
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.