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.