alexmnv/postgres_ip_to_int

Created July 10, 2015 08:15

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/alexmnv/6d79c990367796c76e81.js"></script>
Save alexmnv/6d79c990367796c76e81 to your computer and use it in GitHub Desktop.

Download ZIP

Postgresql, cast inet to bigint (ip to integer)

Raw

postgres_ip_to_int

SELECT (ip - '0.0.0.0'::inet) as ip_integer

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment