Re: Per-column collation, work in progress
Andrew Dunstan <andrew@dunslane.net>
From: Andrew Dunstan <andrew@dunslane.net>
To: Greg Stark <gsstark@mit.edu>
Cc: Pavel Stehule <pavel.stehule@gmail.com>, Peter Eisentraut <peter_e@gmx.net>, pgsql-hackers@postgresql.org
Date: 2010-09-26T13:54:29Z
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