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

Query

From: Eduardo Vázquez Rodríguez <evazquez(at)insys-corp(dot)com(dot)mx>
To: Postgres <pgsql-novice(at)postgresql(dot)org>
Subject: Query
Date: 2004-08-27 22:39:43
Message-ID: 412FB82F.9030303@insys-corp.com.mx (view raw or flat)
Thread:
Lists: 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

Responses

  • Re: Query at 2004-08-27 23:16:17 from Eduardo Vázquez Rodríguez

pgsql-novice by date

Next:From: Eduardo Vázquez RodríguezDate: 2004-08-27 23:16:17
Subject: Re: Query
Previous:From: Betsy BarkerDate: 2004-08-27 21:53:28
Subject: Re: pgsql functions and transactions?

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