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  (Florian Pflug <fgp@phlo.org>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: default privileges wording
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Re: starting to review the Extend NOT NULL representation to pg_constraint patch