Order by in Postgresql to sort IP address?

Question

I wish to sort a list of IP address.

Is there any function in Postgresql to use with the order by like INET_ATON in MySql ?

My current IP is on string format.

Answer 1

You can order your IP address column IP_Address with something like this:

SELECT * FROM MyTable ORDER BY inet(IP_Address)

See the documnetation for further reference.

Edit:

This is actually not a function but a type cast to the postgres integrated type for IP addresses.