On Mon, Jul 04, 2005 at 12:13:27PM -0300, Alejandro D. Burne wrote:
> May be this is an off topic, but the question now is how to change or
> find a locale that include spaces in sort order.
You can hack the locale definitions from the GNU C library. Start by
getting the source and reading it --
Martjin, this little example show your answer:
$ LANG=es_AR
$ export LANG
$ touch 'villa'
$ touch 'villa f'
$ touch 'villaa'
$ touch 'villat'
$ ls | sort
villa
villaa
villa f
villat
May be this is an off topic, but the question now is how to change or
find a locale that include spaces in sort orde
On Sat, Jul 02, 2005 at 11:28:12AM -0300, Alejandro D. Burne wrote:
> Hi, maybe there is a problem with sorting latin10? Seems to be like
> spaces don't exists just sorting.
It's not the encoding, it's the locale. For example, the en_US sorts in
dictionary order (ignore spaces and case).
Hope thi
Maybe I'm wrong, but this "feature" I don't see it in any other rdbms ;-)
2005/7/2, Tom Lane <[EMAIL PROTECTED]>:
> "Alejandro D. Burne" <[EMAIL PROTECTED]> writes:
> > Hi, maybe there is a problem with sorting latin10? Seems to be like
> > spaces don't exists just sorting.
>
> The guys who write
"Alejandro D. Burne" <[EMAIL PROTECTED]> writes:
> Hi, maybe there is a problem with sorting latin10? Seems to be like
> spaces don't exists just sorting.
The guys who write the locale specifications think that's a feature,
not a bug ;-)
If you don't want it, either use C locale or create your ow
Hi, maybe there is a problem with sorting latin10? Seems to be like
spaces don't exists just sorting.
Version() ->PostgreSQL 8.0.2 on i686-redhat-linux-gnu,
compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3)
SELECT nombreasociado, codigoasociado
FROM Asociados
WHERE nombreasociado LIK
