Re: More thoughts on sorting - Mailing list pgsql-hackers

From Greg Stark
Subject Re: More thoughts on sorting
Date
Msg-id 407d949e0908011401m61f292c3qd8a018510fffea91@mail.gmail.com
Whole thread Raw
In response to Re: More thoughts on sorting  (Martijn van Oosterhout <kleptog@svana.org>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL 8.4.1 ?
Next
From: "Kevin Field"
Date:
Subject: Re: 8.4 win32 shared memory patch