Larry Rosenman <ler(at)lerctr(dot)org> writes:
>> Ugh. cidr doesn't appear to cast to text. You may be able to go through
>> inet, but I'm not really sure because I haven't really used those types.
> looks like I can, **BUT** is this the RIGHT thing? I suspect it SHOULD
> cast to text. IMNSHO.
Probably. We have an inet->text cast, and the same function would work
for cidr->text. I think it's just an oversight that there's no such
entry in pg_cast. You could add one by hand ...
regards, tom lane