Curious result from text ( netmask ( inet ) ) functions.
spidermon=# SELECT version();
version
--------------------------------------------------------------
PostgreSQL 7.1.2 on i386--freebsd4.3, compiled by GCC 2.95.3
(1 row)
spidermon=# SELECT netmask ( '192.168.1.1/28' ) ;
netmask
-----------------
255.255.255.240
(1 row)
spidermon=# SELECT text ( netmask ( '192.168.1.1/28' ) );
text
--------------------
255.255.255.240/32 - ??????
(1 row)
--
Vadim I. Passynkov, Axxent Corp.
mailto:pvi@axxent.ca
"Vadim I. Passynkov" <pvi@axxent.ca> writes:
spidermon=# SELECT text ( netmask ( '192.168.1.1/28' ) );
text
--------------------
255.255.255.240/32 - ??????
(1 row)
That's what it's defined to do. See
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/functions-net.html
regards, tom lane