| From: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
| Cc: | Amir Hardon <hardon(at)actcom(dot)co(dot)il>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: sorting RTL languages. |
| Date: | 2003-02-03 03:42:53 |
| Message-ID: | 5.1.0.14.1.20030203113934.02e02150@mbox.jaring.my |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-02-03 04:24:43 | Re: Query plan question, and a memory leak |
| Previous Message | Lincoln Yeoh | 2003-02-03 03:37:47 | Re: DBI driver and transactions |