Обсуждение: Inconsistent casts

Поиск
Список
Период
Сортировка

Inconsistent casts

От
Peter Eisentraut
Дата:
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.

-- 
Peter Eisentraut   peter_e@gmx.net



Re: Inconsistent casts

От
Alvaro Herrera
Дата:
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"



Re: Inconsistent casts

От
Tom Lane
Дата:
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