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') > inse

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 app