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.
In response to
pgsql-hackers by date
|Next:||From: Josh Berkus||Date: 2011-06-30 17:00:51|
|Subject: Re: time-delayed standbys|
|Previous:||From: David E. Wheeler||Date: 2011-06-30 16:58:42|
|Subject: Re: Range Types, constructors, and the type system|