Re: Summary: what to do about INET/CIDR

* Tom Lane <tgl@sss.pgh.pa.us> [001109 10:30]:
> Peter Eisentraut <peter_e@gmx.net> 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.
What is the *PHILOSOPHICAL* objection to text() in this case?

It's a TEXT output? 

LER
> 
>             regards, tom lane
-- 
Larry Rosenman                      http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749