Search Postgresql Archives

int to inet conversion

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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: smime.p7s
Description: S/MIME Cryptographic Signature


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux