'Ordering differences between Postgres instances on different machines (same locale)
I have two Postgres 9.1 instances: one local, installed via Postgres.app on OS X, and one remote, on Heroku. I've ensured that lc_collate is en_US.UTF-8 on both machines but am still seeing different behavior between the two.
On my local instance, SELECT 'i' > 'N' returns t whereas remotely it returns f. Given that I've already checked lc_* on both systems, what explains the difference I'm seeing?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|