On Jun 30, 2011, at 9:34 AM, Jeff Davis wrote: > Then how do you get a text range that doesn't correspond to the > LC_COLLATE setting?
You cast it. > Does that mean you couldn't dump/reload from a > system with one collation and get the same values in a system with a > different collation? That would be very strange. No, pg_dump should always explicitly cast things. But there should be a reasonable default behavior if I'm in psql and don't cast. > Or, what about other types that just happen to have multiple useful > total orders? Cast where you need it explicit, and have a reasonable default when it's not cast. Best, David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
