| From: | Kaj-Michael Lang <milang(at)tal(dot)org> |
|---|---|
| To: | pgsql-general(at)postgreSQL(dot)org |
| Subject: | order by |
| Date: | 1998-06-11 11:46:46 |
| Message-ID: | Pine.LNX.3.96.980611144232.20423A-100000@toriamos.tal.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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(at)tal(dot)org
Kaskentie 5 C9 http://www.tal.org/
20720 Turku ftp://ftp.tal.org/
FINLAND klang(at)abo(dot)fi
------------------------------------------------------------------------------
Keyboard not found - press any key to continue
------------------------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cho Yan Wong | 1998-06-11 12:28:12 | Date problems |
| Previous Message | Marin D | 1998-06-11 10:00:37 | Re: [GENERAL] Sequences : getting back the nextval() result on an insert |