On Tue, Dec 06, 2005 at 04:10:22PM +0800, Christopher Kings-Lynne wrote: > >Sheesh, arbitrary restrictions ;-) Something like this then: > > > >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; > > Cool, and now the reverse? :D
Tom posted one just a couple of days ago: http://archives.postgresql.org/pgsql-general/2005-12/msg00191.php > (I'll credit you in the MySQL Compat Library code btw) If you're > interested, you'd be welcome to join the project btw... I haven't been following it but I might have some time. Is there a TODO list? The one I see on pgfoundry is empty. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
