Re: [SQL] Automatic casting

2003-02-06 Thread Josh Berkus
Vicente, > if I try nodo_fecha_activ<= 104422680 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

[SQL] Automatic casting

2003-02-06 Thread Vicente Alabau Gonzalvo
Is there any way of doing nodo_fecha_activ<= 104422680::numeric without casting? nodo_fecha_activ is numeric if I try nodo_fecha_activ<= 104422680 then it gives me this error ERROR: Unable to identify an operator '<=' for types 'numeric' and 'double precision' --