Postgres Pro
Downloads
Home   >   mailing lists

order by - Mailing list pgsql-general

From Kaj-Michael Lang
Subject order by
Date
Msg-id Pine.LNX.3.96.980611144232.20423A-100000@toriamos.tal.org
Whole thread Raw
In response to Date problems  (Cho Yan Wong <pwong@pobox.leidenuniv.nl>)
Responses Re: [GENERAL] order by  (Oleg Broytmann <phd@comus.ru>)
Re: [GENERAL] order by  (dave madden <dhm@paradigm.webvision.com>)
List pgsql-general
Tree view 
I have stored IP's in a table using a varchar(15) field. My problem is how
to make the order by list the IP's the correct order like:

192.168.1.1
192.168.1.6
192.168.1.10

now it sorts them like:

192.168.1.1
192.168.1.10
192.168.1.6

is it possible to get them sorted the right way ?

------------------------------------------------------------------------------
Kaj-Michael Lang        milang@tal.org
Kaskentie 5 C9            http://www.tal.org/
20720 Turku            ftp://ftp.tal.org/
FINLAND                klang@abo.fi
------------------------------------------------------------------------------
               Keyboard not found - press any key to continue
------------------------------------------------------------------------------

pgsql-general by date:

Previous
From: Cho Yan Wong
Date:
Subject: Date problems
Next
From: Oleg Broytmann
Date:
Subject: Re: [GENERAL] order by