Re: sorting RTL languages.

On Sun, 2 Feb 2003, Tom Lane wrote:

> Amir Hardon <hardon@actcom.co.il> writes:
> > I need to get sorted data from a database I have on postgresql,
> > the data is in Hebrew which is written from right to left,
> > now when I do a SELECT ... ORDER BY ... I get the information sorted by the
> > last letter first.
> > Is there anyway to overcome this? other than holding the data reversed?
>
> If your machine has a Hebrew locale setting in which sorting is done
> right-to-left, then you could initdb in that locale, and text sorting
> would happen according to the locale rules.
>
> If you want only some of your columns to be sorted per Hebraic rules,
> I'm afraid we have no good answer at present :-( --- database locale
> settings are all-or-nothing, at least as far as sort ordering goes.

Presumably it is feasible to create a new rtl text type. Possibly not pretty
though.


--
Nigel J. Andrews