Re: collation

I'm going to be dealing with collations and locales not provided by anyone.
It sounds like I can't create my own collations. Is that true? If so, what
do I have to do to create my own locales?

Steve Miller

On 01/26/2003 12:49:15 PM pgsql-novice-owner wrote:

>=?ISO-8859-1?Q?Jens_=D8stergaard_Petersen?= <oesterg(at)hum(dot)ku(dot)dk> writes:
>> Thank for the tips, Oliver and Paul! I take it then that there are no
>> means of constructing collation tables (like I do in FrontBase), that
>> allow me to control which characters are equalled with which characters
>> in searches - this is a part of SQL92, I believe.
>
>I'm not sure whether SQL92 allows for user-defined collations, but in
>any case we don't yet have any of the SQL-specified facilities in that
>area. Postgres just sits atop the libc locale facilities (strcoll()
>etc). If you do not like any of the locales available on your machine
>then you need to provide your own locale definition. I've never done
>it, so I can't say what degree of wizardry is needed... but it's
>certainly possible.
>
>BTW, if you do find yourself issuing lots of queries like
> select * from ... where lower(col) = lower('foo');
>then you'll want to create a functional index on lower(col) to
>make this go faster.
>
> regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster