Inconsistent casts

Peter Eisentraut dijo:

Since almost every cast to "text" is implicit, then I believe so should

inet -> text
macaddr -> text
int4 -> varchar
int8 -> varchar

which are currently not.

Also, some casts seem to be missing; numeric -> text, for example.

--
Alvaro Herrera (<alvherre[a]atentus.com>)
"La naturaleza, tan fragil, tan expuesta a la muerte... y tan viva"

Peter Eisentraut <peter_e@gmx.net> writes:

Since almost every cast to "text" is implicit, then I believe so should
inet -> text
macaddr -> text
int4 -> varchar
int8 -> varchar
which are currently not.

I would like to see us *eliminate* implicit casts to text. Not add more.

See my prior rants on subject... but the core of the matter is that if
every datatype can be implicitly casted to text then you have no type
safety worthy of the term. We have open bug reports that reduce to this.

regards, tom lane