Re: inet to bigint?

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