On Tue, Dec 06, 2005 at 01:05:12AM -0700, Michael Fuhr wrote: > CREATE FUNCTION inet2num(inet) RETURNS numeric AS $$ > DECLARE > a text[] := string_to_array(host($1), '.'); > BEGIN > RETURN a[1]::numeric * 16777216 + > a[2]::numeric * 65536 + > a[3]::numeric * 256 + > a[4]::numeric; > END; > $$ LANGUAGE plpgsql IMMUTABLE STRICT;
I should point out that this is only for IPv4, so a family() check might be in order. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
