int to inet conversion - Mailing list pgsql-general

From Anton Nikiforov
Subject int to inet conversion
Date
Msg-id 43922CCD.7000108@nikiforov.ru
Whole thread Raw
Responses Re: int to inet conversion
List pgsql-general
Dear All.
is there any function that can translate INT to INET type?
the table contains ip and mask in different fields (int fields):

  ip          | integer               | default 0
  mask        | integer               | default -1

db=> select ip, mask from ips limit 2;
      ip      | mask
-------------+------
  -1062726656 | -256
  -1062724096 | -256

But i need inet or sidr records :)

Best regards,
Anton

Attachment

pgsql-general by date:

Previous
From: stig erikson
Date:
Subject: Re: news.postgresql.org slow
Next
From: Tom Lane
Date:
Subject: Re: int to inet conversion