Thread: order by int

order by int

From

"Duncan Adams (DNS)"

Date:

26 July 2002, 11:24:26

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>

Re: order by int

From

"Henshall, Stuart - WCP"

Date:

26 July 2002, 13:23:18

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.adams@vcontractor.co.za]
> Sent: 26 July 2002 13:26
> To: pgsql-novice@postgresql.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@postgresql.org)
>

Re: order by int

From

"Duncan Adams (DNS)"

Date:

26 July 2002, 13:44:13

ur right, for some , dont know what, i thought it as an int field, i now also find out that it can hold letters as well as numbers, so i guess that theory out the window.

-----Original Message-----
From: Henshall, Stuart - WCP [mailto:SHenshall@westcountrypublications.co.uk]
Sent: Friday, July 26, 2002 4:16 PM
To: 'Duncan Adams (DNS)'; pgsql-novice@postgresql.org
Subject: RE: [NOVICE] order by int

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.adams@vcontractor.co.za]
> Sent: 26 July 2002 13:26
> To: pgsql-novice@postgresql.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@postgresql.org)
>