Re: More thoughts on sorting

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: More thoughts on sorting
Дата
Msg-id 407d949e0908011401m61f292c3qd8a018510fffea91@mail.gmail.com
обсуждение исходный текст
Ответ на Re: More thoughts on sorting  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-hackers
On Sat, Aug 1, 2009 at 6:17 PM, Martijn van Oosterhout<kleptog@svana.org> wrote:
> On Sat, Aug 01, 2009 at 09:37:11AM +0200, PFC wrote:
>>       Actually, I think (see the bottom of my last email) that this would be a
>> good argument for the per-column COLLATE patch...
>
> Standard SQL COLLATE support is per column anyway, so just implementing
> that will solve all the problems anyway.

Well it's more flexible than that. You can specify the collation to
use in your order by clause or comparison operator. So even for the
same column it can be different for different queries.


--
greg
http://mit.edu/~gsstark/resume.pdf


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL 8.4.1 ?
Следующее
От: "Kevin Field"
Дата:
Сообщение: Re: 8.4 win32 shared memory patch