3 ms·
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
by o11c 2y ago
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.
- yen223 2y agoGiven 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.