The following bug has been logged online:
Bug reference: 4277
Logged by: x
Email address: noreply(at)postgresql(dot)org
PostgreSQL version: n/a
Operating system: n/a
Description: Feature request inet type cast numeric values
Details:
SELECT inet 2130706433;
Should return:
?column?
--------
127.0.0.1
This would emulate the functionality:
CREATE OR REPLACE FUNCTION inet_ntoa(bigint) RETURNS text AS '
SELECT (($1>>24) & 255::int8) || ''.'' ||
(($1>>16) & 255::int8) || ''.'' ||
(($1>>8) & 255::int8) || ''.'' ||
($1 & 255::int8) as result
'
LANGUAGE 'SQL';