On Tue, Dec 06, 2005 at 03:31:59PM +0800, Christopher Kings-Lynne wrote: > OK, I give up - how do I convert an INET type to a NUMERIC > representation of its network address?
How about: CREATE FUNCTION inet2num(inet) RETURNS numeric AS $$ use Socket; return unpack("N", inet_aton($_[0])); $$ LANGUAGE plperlu IMMUTABLE STRICT; SELECT inet2num('127.0.0.1'); inet2num ------------ 2130706433 (1 row) -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings