CREATE OR REPLACE FUNCTION billstat.int82ip(int8)
  RETURNS text AS
'
select  ($1&(255::int4<<24)>>24)::text || \'.\' ||
	($1&(255::int4<<16)>>16)::text || \'.\' ||
	($1&(255::int4<<8)>>8)::text || \'.\' ||
	($1&255)::text
'
  LANGUAGE 'sql' IMMUTABLE;

CREATE OR REPLACE FUNCTION billstat.ip2int8(varchar)
  RETURNS int8 AS
'
select  (split_part($1,\'.\',1)::int8<<24)::int8 +(split_part($1,\'.\',2)::int8<<16)::int8 +(split_part($1,\'.\',3)::int8<<8)::int8 + split_part($1,\'.\',4)::int8;
'
  LANGUAGE 'sql' IMMUTABLE;