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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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