select * from pc order by ip;
이러면
xxx.xxx.xxx.100
xxx.xxx.xxx.110
xxx.xxx.xxx.2
xxx.xxx.xxx.210
xxx.xxx.xxx.3
요런식으로 정렬이 되는데요..
이런식으로 나오게 할려면 어떻게 해야하나요..
부탁드립니다...
test=# create TEMP table pc (ip text,ip2 inet); CREATE TABLE test=# \d pc Table "pg_temp_25.pc" Column | Type | Modifiers --------+------+----------- ip | text | ip2 | inet |
test=# SELECT * from pc order by ip; ip | ip2 ---------------+--------------- 192.168.0.1 | 192.168.0.1 192.168.0.100 | 192.168.0.100 192.168.0.2 | 192.168.0.2 192.168.0.200 | 192.168.0.200 192.168.1.1 | 192.168.1.1 192.168.100.1 | 192.168.100.1 192.168.2.1 | 192.168.2.1 (7 rows)
test=# SELECT * from pc order by ip2; ip | ip2 ---------------+--------------- 192.168.0.1 | 192.168.0.1 192.168.0.2 | 192.168.0.2 192.168.0.100 | 192.168.0.100 192.168.0.200 | 192.168.0.200 192.168.1.1 | 192.168.1.1 192.168.2.1 | 192.168.2.1 192.168.100.1 | 192.168.100.1 (7 rows)
test=# SELECT * from pc order by ip::inet; ip | ip2 ---------------+--------------- 192.168.0.1 | 192.168.0.1 192.168.0.2 | 192.168.0.2 192.168.0.100 | 192.168.0.100 192.168.0.200 | 192.168.0.200 192.168.1.1 | 192.168.1.1 192.168.2.1 | 192.168.2.1 192.168.100.1 | 192.168.100.1 (7 rows)
우오~ 이렇게 간단한 방법이....^^; 감사합니다..
