Skip site navigation (1) Skip section navigation (2)

Re: order by int

From: "Henshall, Stuart - WCP" <SHenshall(at)westcountrypublications(dot)co(dot)uk>
To: "'Duncan Adams (DNS)'" <duncan(dot)adams(at)vcontractor(dot)co(dot)za>,pgsql-novice(at)postgresql(dot)org
Subject: Re: order by int
Date: 2002-07-26 14:16:12
Message-ID: E2870D8CE1CCD311BAF50008C71EDE8E01F74942@MAIL_EXCHANGE (view raw or flat)
Thread:
Lists: pgsql-novice
It looks like you are ordering by text rather than a number.
If you need to convert text to a number it can be done like so:
cast('123' AS int4)
so for ordering the query might look like:
select * from tbl order by CAST(text_field AS int4);
hth,
- Stuart

> -----Original Message-----
> From: Duncan Adams (DNS) [mailto:duncan(dot)adams(at)vcontractor(dot)co(dot)za]
> Sent: 26 July 2002 13:26
> To: pgsql-novice(at)postgresql(dot)org
> Subject: [NOVICE] order by int
> 
> 
> Hi all
>  
> quick question 
> 
> how does one get 
> 1
> 2
> 3
> 4
> 5
> 6
> 7
> 8
> 9
> 10
> 11
> instead of 
> 1
> 10
> 11
> 2
> 3
> 4
> 5
> 6
> 7
> 8
> 9
> when one does an order by <int>
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to 
> majordomo(at)postgresql(dot)org)
> 

pgsql-novice by date

Next:From: Duncan Adams (DNS)Date: 2002-07-26 14:45:56
Subject: Re: order by int
Previous:From: Daniel L BantaDate: 2002-07-26 14:00:45
Subject: initdb initialization problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group