Re: sorting RTL languages.

At 04:08 PM 2/2/03 -0500, Tom Lane wrote:

>Well, if it was *only* a matter of rtl then he could do
>         ORDER BY reverse(foo)
>I don't think we have a string-reversing function (reverse('foo') = 'oof')
>at the moment, but one would be easy to write.
>
>But I'm assuming the rtl property is just one of the ways in which
>Hebraic sorting differs from plain ASCII... so he really needs a locale.

Or an imaginary function: order by lang_order('hebrew',foo)

Where lang order converts stuff so that in a C locale it's ordered correctly.

Is that sort of thing possible? There'd be a performance penalty, but it
could allow better flexibility.

Link.