Re: Followup from yesterday's PL/pgSQL fun...

Larry Rosenman <ler@lerctr.org> writes:
> 1) should quote_literal find a ::text conversion on it's own?

It won't, because the pg_cast entry for inet->text is marked "explicit
casts only".  In general I don't like implicit casts across datatype
categories, and am hoping to move in the direction of marking more such
casts as explicit-only.

> 2) can text(cidr) be added to the default pg_cast table?

I'll make that happen for 7.4.

> 3) how can I add text(cidr) myself?

Read the pg_cast description in 
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=catalogs.html
Insert a suitable row.
        regards, tom lane