Postgres Pro
Downloads
Home   >   mailing lists

Automatic casting - Mailing list pgsql-sql

From Vicente Alabau Gonzalvo
Subject Automatic casting
Date
Msg-id 3E3E5BB5.1010105@capgemini.es
Whole thread Raw
Responses Re: Automatic casting
List pgsql-sql
Tree view 
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'

pgsql-sql by date:

Previous
From: Vicente Alabau Gonzalvo
Date:
Subject: numeric when compared to literal
Next
From: thatsamiam@yahoo.com (Sam Iam)
Date:
Subject: get # of rows while doing SELECT with LIMIT at same time ?