| From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Amir Hardon <hardon(at)actcom(dot)co(dot)il>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: sorting RTL languages. |
| Date: | 2003-02-02 20:59:28 |
| Message-ID: | Pine.LNX.4.21.0302022057480.20150-100000@ponder.fairway2k.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, 2 Feb 2003, Tom Lane wrote:
> Amir Hardon <hardon(at)actcom(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-02-02 21:08:40 | Re: sorting RTL languages. |
| Previous Message | Nigel J. Andrews | 2003-02-02 20:57:17 | Re: basic access problem on W2K |