Query - Mailing list pgsql-novice

From Eduardo Vázquez Rodríguez
Subject Query
Date
Msg-id 412FB82F.9030303@insys-corp.com.mx
Whole thread Raw
List pgsql-novice
Hi I have a field which vaules are numbers.

numbers
------
2
3
4
1
5
7
8
10
1
13
6
7
18


When I run a query asking for the field numbers sorted which look
something like this
SELECT numbers FROM TABLE
ORDER BY 1 ASC

And I get something like this
1
10
13
18
2
3
4, etc

Instead of I was expecting

1
2
3
etc
10
13
18


How can I fix it

Thanks in advanced

pgsql-novice by date:

Previous
From: Betsy Barker
Date:
Subject: Re: pgsql functions and transactions?
Next
From: Eduardo Vázquez Rodríguez
Date:
Subject: Re: Query