Followup from yesterday's PL/pgSQL fun... - Mailing list pgsql-sql

I posted:

Also, this is what I wound up with for that line, which seems ugly, because
it couldn't find a quote_literal(inet) without the ::text on it:
 quote_literal(NEW.netblock::inet::text) ;


Is that right?



Can I ask 3 questions:

1) should quote_literal find a ::text conversion on it's own?
2) can text(cidr) be added to the default pg_cast table?
3) how can I add text(cidr) myself?



-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749