Dragan Matic <mlists(at)panforma(dot)co(dot)yu> writes:
> Is there some way to make Postgres sort elements
> in this way (setting sort order or collation, I suppose)?
C locale would sort that way; you appear to be using some other locale.
I concur with the nearby suggestions that you should consider a more
appropriate datatype, if all your data will be integers. Operations on
integers will be lots faster than operations on strings.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Joe Conway||Date: 2004-05-20 16:11:58|
|Subject: Re: Dblink question|
|Previous:||From: Stephan Szabo||Date: 2004-05-20 16:08:48|
|Subject: Re: problem with sorting using 'ORDER BY' when character|