Re: Per-column collation, work in progress

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Per-column collation, work in progress
Date: 2010-09-26 13:54:29
Message-ID: 4C9F5095.6020904@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 09/26/2010 09:37 AM, Greg Stark wrote:
> We could have a
> encoded_text data type which includes both the encoding and the string
> and which any comparison function automatically handles conversion
> based on the encoding of the collation requested -- but I wouldn't
> want that to be the default text datatype. It would impose a lot of
> overhead on the basic text operations and magnify the effects of
> choosing the wrong collation.

Yeah, but it would be a nice gadget to have.

cheers

andrew

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2010-09-26 15:11:22 Re: Stalled post to pgsql-committers
Previous Message Heikki Linnakangas 2010-09-26 13:39:19 Re: Stalled post to pgsql-committers