CREATE OR REPLACE FUNCTION "public"."inet_ntoa" (bigint) RETURNS text AS
$body$
select ($ 1  >>  24  &  255 )
       || '.' || ($ 1  >>  16  &  255 )
       || '.' || ($ 1  >>  8  &  255 )
       || '.' || ($ 1  &  255 )
$body$
LANGUAGE 'sql' IMMUTABLE RETURNS NULL ON NULL INPUT SECURITY INVOKER;

CREATE OR REPLACE FUNCTION "public"."inet_aton" (text) RETURNS bigint AS
$body$
select ( 0 
      <<  8  | split_part($ 1 ,'.', 1 )::int
      <<  8  | split_part($ 1 ,'.', 2 )::int
      <<  8  | split_part($ 1 ,'.', 3 )::int
      <<  8  | split_part($ 1 ,'.', 4 )::int) :: bigint
$body$
LANGUAGE 'sql' IMMUTABLE RETURNS NULL ON NULL INPUT SECURITY INVOKER;