"Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
>> 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.
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.
regards, tom lane