Re: Range Types and extensions

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: Range Types and extensions
Дата
Msg-id 1307467249.2402.175.camel@jdavis
обсуждение исходный текст
Ответ на Re: Range Types and extensions  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Range Types and extensions  (Darren Duncan <darren@darrenduncan.net>)
Re: Range Types and extensions  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-hackers
On Tue, 2011-06-07 at 11:15 -0400, Tom Lane wrote:
> Merlin Moncure <mmoncure@gmail.com> writes:
> > right. hm -- can you have multiple range type definitions for a
> > particular type?
> 
> In principle, sure, if the type has multiple useful sort orderings.

Right. Additionally, you might want to use different "canonical"
functions for the same subtype.

> I don't immediately see any core types for which we'd bother.

Agreed.

> BTW, Jeff, have you worked out the implications of collations for
> textual range types?

Well, "it seems to work" is about as far as I've gotten.

As far as the implications, I'll need to do a little more research and
thinking. But I don't immediately see anything too worrisome.

Regards,Jeff Davis




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alex Hunsaker
Дата:
Сообщение: Re: [Pgbuildfarm-members] CREATE FUNCTION hang on test machine polecat on HEAD
Следующее
От: Joshua Berkus
Дата:
Сообщение: Re: reducing the overhead of frequent table locks - now, with WIP patch