The following bug has been logged online: Bug reference: 4277 Logged by: x Email address: [EMAIL PROTECTED] 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'; -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs