Re: int to inet conversion [or Re: inet to bigint?]

Hi Kai,

There are some rather simplistic functions to convert 32bit inet values 
to and from bigints in the mysql compatibility project:

http://pgfoundry.org/projects/mysqlcompat/

In the miscellaneous.sql.

Chris

Kai wrote:
> Hello All,
> 
> I've been pondering the discussed subject a few times, and came along a few
> things that I think are missing from the default set of typeconversions
> within postgres.
> 
> After working regularly with inet values in sql, it would be nice to be able
> to do this:
> 
>     => select '192.168.1.1'::inet + 1 as result;
>        result    
>     -------------
>      192.168.1.2
>     (1 row)
> 
>     => select '192.168.1.255'::inet - '192.168.1.0'::inet as difference;
>        difference
>     ----------------
>      255
>     (1 row)
> 
> or simply this:
> 
>     => select '192.168.1.1'::inet::bigint
>      bigint 
>     ------------
>      3232235777
> 
> 
> In the old postgres 7.3 the data was stored in the database being a big
> integer anyway, but in the new ipv6 compatible stuff I lost track. I can
> probably write the functions in C if theres more interest in them, but I'm
> not on track on how to define all the casting stuff in the postgresql system
> tables, nor the sticky subject on how to handle ipv6.
> 
> 
> Or maybe someone else was pondering the idea too and is far better at
> writing C? :-)
> 
> 
> My conclusion is that the selects above should be among the default set of
> operations on inet values in PostgreSQL, being subtraction and addition. If
> not I'd like to be proven wrong.
> 
> 
> Regards,
> 
> 
> Kai
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faq