Re: inet to bigint? - Mailing list pgsql-hackers

From Michael Fuhr
Subject Re: inet to bigint?
Date
Msg-id 20051206081508.GA77261@winnie.fuhr.org
Whole thread Raw
In response to Re: inet to bigint?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: inet to bigint?
Next
From: Nicolai Tufar
Date:
Subject: Re: [PATCHES] snprintf() argument reordering not working under Windows in 8.1