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