order by

Kaj-Michael Lang <milang@tal.org>

From: Kaj-Michael Lang <milang@tal.org>
To: pgsql-general@postgreSQL.org
Date: 1998-06-11T11:46:46Z
Lists: pgsql-general
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
------------------------------------------------------------------------------