Automatic casting

From: Vicente Alabau Gonzalvo <vicente(dot)alabau-gonzalvo(at)cgey(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Automatic casting
Date: 2003-02-03 12:08:21
Message-ID: 3E3E5BB5.1010105@capgemini.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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'

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Vicente Alabau Gonzalvo 2003-02-03 12:45:55 numeric when compared to literal
Previous Message Bhuvan A 2003-02-03 10:54:32 Format in psql