Peter Eisentraut <[EMAIL PROTECTED]> writes:
>> Well, we need *some* way to extract a representation like "w.x.y.z/n".
>> If you don't like text() as the name of that formatting function,
>> suggest another name...
> all_octets(cidr)::text maybe?
No, because that doesn't accurately describe what it does for inet
items --- those'd be shown with all octets anyway. For inet, the
critical thing this function will do is force the netmask to be shown
even if it's /32.
Given that we are using host() for the function that shows just the
IP address part of an inet/cidr value, how about hostandmask() for
the function that always shows everything?
I still prefer text() though.
regards, tom lane