What I Wish Someone Told Me About Postgres

Re:What I Wish Someone Told Me About Postgres by o11c on Tuesday November 12, 2024 @01:09PM (#42118013)

Note that case handling is a place where postgres (which folds to lowercase) violates the standard (which folds to uppercase).

This is mostly irrelevant since you really shouldn't be mixing quoted with unquoted identifiers, and introspection largely isn't standardized.

[ Parent | on HN ]

Re:What I Wish Someone Told Me About Postgres by yen223 on Tuesday November 12, 2024 @02:46PM (#42118952)

Given that other mainstream RDBMSes lets you configure how case handling should happen, Postgres is arguably the closest to the standard.

Usual caveat of how nobody sticks to the ANSI standard anyway applies.

[ Parent | on HN ]