Re: [GENERAL] problem with sorting using 'ORDER BY' when character field is filled with numerical values

2004-05-20 Thread Tom Lane
Dragan Matic [EMAIL PROTECTED] 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

Re: [GENERAL] problem with sorting using 'ORDER BY' when character

2004-05-20 Thread Stephan Szabo
On Thu, 20 May 2004, Dragan Matic wrote: If I have a table t with column c which is defined as char(5) and fill it with following values: insert into t (c) values ('1') insert into t (c) values ('2') insert into t (c) values ('3') insert into t (c) values ('4') insert into