Re: numeric SORT order
От | Ben Ausden |
---|---|
Тема | Re: numeric SORT order |
Дата | |
Msg-id | 4174BB57B89ED411A8BB000102A30F51406156@NAVY обсуждение исходный текст |
Ответ на | numeric SORT order (Ben Ausden <benedict@navyblue.com>) |
Ответы |
Re: numeric SORT order
|
Список | pgsql-general |
thanks Mitch. the problem is that casting to int won't work for non-numeric data (obviously), and I can't guarantee that values in this column will definitely be numeric... I should have made that clearer in my post. Ideally I'd like to sort numbers in numeric order and text in regular alphabetic order, like: 1,2,3,40,50,a,b,c,d,e...[etc] -ben > -----Original Message----- > From: Mitch Vincent [mailto:mitch@doot.org] > Sent: 28 January 2002 21:07 > To: Ben Ausden; pgsql-general@postgresql.org > Subject: Re: [GENERAL] numeric SORT order > > > select * from whatever order by field1::text::integer; > > seems to work.. > > > ----- Original Message ----- > From: "Ben Ausden" <benedict@navyblue.com> > To: <pgsql-general@postgresql.org> > Sent: Monday, January 28, 2002 1:47 PM > Subject: [GENERAL] numeric SORT order > > > > Hi, > > > > > > Is there any way to persuade postgresql to sort a VARCHAR column in > numeric > > order first, and then text order? > > > > e.g > > > > 1, 2, 3, 10, 20, 25, 30, 40 > > > > instead of: > > > > 1, 10, 2, 20, 25, 3, 30, 40 >
В списке pgsql-general по дате отправления: