Re: Ok, how do I debug THIS?

Larry Rosenman <ler@lerctr.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