Обсуждение: Automatic casting

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

Automatic casting

От
Vicente Alabau Gonzalvo
Дата:
Is there any way of doing nodo_fecha_activ<= 1044226800000::numeric
without casting?

nodo_fecha_activ is numeric


if I try nodo_fecha_activ<= 1044226800000 then it gives me this error
ERROR:  Unable to identify an operator '<=' for types 'numeric' and 
'double precision'



Re: Automatic casting

От
"Josh Berkus"
Дата:
Vicente,


> if I try nodo_fecha_activ<= 1044226800000 then it gives me this error
> ERROR:  Unable to identify an operator '<=' for types 'numeric' and
> 'double precision'

This is a known problem that will be fixed in a later version of
Postgres.  For now, you have to cast.

-Josh