Re: Range Types, constructors, and the type system
| От | Peter Eisentraut |
|---|---|
| Тема | Re: Range Types, constructors, and the type system |
| Дата | |
| Msg-id | 1309383893.4921.2.camel@vanquo.pezone.net обсуждение исходный текст |
| Ответ на | Re: Range Types, constructors, and the type system ("David E. Wheeler" <david@kineticode.com>) |
| Ответы |
Re: Range Types, constructors, and the type system
|
| Список | pgsql-hackers |
On ons, 2011-06-29 at 10:15 -0700, David E. Wheeler wrote:
> On Jun 29, 2011, at 10:13 AM, Florian Pflug wrote:
>
> > Because there might be more than one range type for a
> > base type. Say there are two range types over text, one
> > with collation 'de_DE' and one with collation 'en_US'.
> > What would the type of
> > range('foo', 'foooo')
> > be?
>
> The one that corresponds to the current LC_COLLATE setting.
Yes, or more generally, we have logic that determines, for example, what
collation to use for
'foo' < 'foooo'
The same logic can be used to determine what collation to use for
range('foo', 'foooo')
(In fact, if you implement range() as a user-space function, that will
happen automatically.)
В списке pgsql-hackers по дате отправления: